RE: Bizgres anyone?
- From: "Milen Kulev" <makulev@xxxxxxx>
- To: <oracledba.williams@xxxxxxxxx>, "'Oracle-L Freelists'" <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 29 Oct 2006 13:30:39 +0100
... 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
Other related posts:
