RE: Bizgres anyone?

From: Milen Kulev <makulev_at_gmx.net>
Date: Sun, 29 Oct 2006 13:30:39 +0100
Message-ID: <000b01c6fb56$0ad861b0$0a00a8c0@trivadis.com>

... just to add.
partioning in Postgres/Bizgres is called "constraint exclusion" and uses table inheritance + Rulesot Triggers to dispatch the rows to the right "partition" (table). It works only when literals are used ;( e.g. there is no dynamic partition pruning as in Oracle ;(. I know there are plans to imlement "real partitioning" in the near future versions of Postgres, but I suppose it will last
another 1-2 years to imlement and test this functionality .. Let me know if you neeed further information about this topic.

As for clustering of data using PG database there are also other projects trying to cover this topic too:

http://www.extendb.com/comparison.php
http://pgpool.projects.postgresql.org/pgpool-II/en/

Regards. Milen

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dennis Williams Sent: Thursday, October 26, 2006 10:25 PM To: Oracle-L Freelists
Subject: Bizgres anyone?

List,

Has anybody heard of Bizgres? It seems to be PostgreSQL adapted for data warehousing. The vendor is Greenplum. Sun has announced a DW Appliance for $250,000 that will include Bizgres. I see where they are implementing table partitioning.

Dennis Williams

--

http://www.freelists.org/webpage/oracle-l Received on Sun Oct 29 2006 - 06:30:39 CST