Re: Questions about Postgres and Oracle

From: Paresh Yadav <yparesh_at_gmail.com>
Date: Wed, 19 Dec 2012 21:59:33 -0500
Message-ID: <CAPXEL0+0_o7inMQQ3sCoB+xwDa+CLL4BNp=4KY-xeQFxf1VBWQ_at_mail.gmail.com>

Kevin,
Fortunately me too :) (didn't start the thread to offend the OT police.)

Thanks for sharing this interesting info. I didn't know about EMC Greenplum UAP can do that, that sounds awesome. What other products can do so (EnterpriseDB)? I didn't see that as being marketed heavily by Greenplum (thousands of partitions) so I always assumed that they scale to large size dbs by clustering.

On the flip side we found a very depressing critique of Greenplum's financial results (which I read in I believe 2011 Nov/Dec time period and I have it saved somewhere to cover my back ) and wondering if this might reflect on the product's strength, stayed away. We don't have a big shop to evaluate a product so we depend on search data for level 1 evaluation. Looks like we missed a very important product in our evaluation (it is by design as we don't have lots of warm bodies to do trial and error). I will give this another look, thanks again!

PS - I believe even though this oracle-l, it is okay to discuss Postgres as long as it is in compared to capabilities of Oracle database.

Paresh

On Wed, Dec 19, 2012 at 9:01 PM, Kevin Closson <ora_kclosson_at_yahoo.com>wrote:

>
> Beyond 100 partitions per instance, one needs to go for clustered Postgres
> database solution and it brings with it all the challenges of a distributed
> databases that NoSQL databases try to solve by staying within compromise
> that were postulated in CAP theorem (
> http://www.julianbrowne.com/article/viewer/brewers-cap-theorem ).
>
> ...I didn't start the thread so I hope to not upset the OT police.
>
> Paresh, at the scale you speak of you need to consider one of the product
> that embeds PostgreSQL and breaks down those walls. Once such product is
> EMC Greenplum UAP. If you want thousands of partitions on a table or even
> on a single column you can do so with that product. Greenplum customers are
> routinely petabyte sized and at the core of that is an adapted PostgreSQL
> kernel.
>
> Now, since this is oracle-l I'll stop there.
>
>
>
>
>

-- 
Thanks
Paresh
416-688-1003


--
http://www.freelists.org/webpage/oracle-l

Received on Thu Dec 20 2012 - 03:59:33 CET