RE: Bizgres anyone?

From: Richard J. Goulet <rgoulet_at_kanbay.com>
Date: Mon, 30 Oct 2006 09:12:55 -0500
Message-ID: <C3EE2ADD31ACF64DAB1B236044A1968D46A946@miaexc01.kanbay.com>

It's about time that PostGreSql got some respect out of the market place over that piece of trash called MySql. Hopefully that will continue, though not for Oracle's sake.     

Dick Goulet, Senior Oracle DBA

45 Bartlett St Marlborough, Ma 01752, USA Tel.: 508.573.1978 |Fax: 508.229.2019 | Cell:508.742.5795

RGoulet_at_kanbay.com
: POWERING TRANSFORMATION  

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Milen Kulev
Sent: Sunday, October 29, 2006 7:31 AM
To: oracledba.williams_at_gmail.com; 'Oracle-L Freelists' Subject: RE: Bizgres anyone?

... 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 Mon Oct 30 2006 - 08:12:55 CST