Slashdot Mirror

> Then I guess the only big thing is, who do you go to if there is a major problem?

Here (http://www.bizgres.org/) or here (http://www.commandprompt.com/) or here (http://www.postgresql.org/support/professional_su pport) perhaps?

About partitioning in PostGreSQL ...
It can be achieved using inheritance. See http://www.bizgres.org/assets/docs/html/tblpartn.h tm#wp135195

PostGreSQL does not provide the "CREATE PARTITION ..." - statement yet but I bet it is only a matter of time.

Notrace

Bizgres seems to use it for an implementation of partitioning in Postgres.

Here is an example of how to use it.

Notrace

what do you prefer for performance on large data warehousing projects?

Netezza. From my brief experience with the product, I can say that it really does live up to their claim of 10-50 times the performance at half the cost. It is absolutely unsuitable for OLTP, but that's no surprise as it is designed for data warehousing with adhoc queries. Nothing else on the market comes close for the price or ease of use.

Bizgres looks like a clone of their architecture and it might be a competitor at some point. Though, it won't be nearly as easy to use. Having a single machine delivered ready to go is a lot easier than setting up a cluster yourself.

I mostly make my living with db2 these days, oracle/informix/sybase/sql server in the past. But I'll gladly start working with postgresql once the BI functionality is in place. But spending any time with mysql's glaring deficiencies in data quality, BI performance, etc in the face of the marketing hype seems too much like y2k work. Yuck.

Keep an eye on Bizgres. Their web site is at www.bizgres.org.

Of course nobody uses the MySQL for serious BI work.

...but some folks believe you've gotta pay money or the app isn't any good.

There are good reasons to pay someone for support, if the people you're paying know their stuff. If you're building enterprise level, mission critical data warehouses, you'll want immediate access to expert help when things go horribly wrong. And Sorbannes/Oxley reinforces that need.

For those seeking paid support, there are several companies working to do interesting things with Pg:

• GreenPlum also working to enhance Pg with the Bizgress project
• EnterpriseDB - working to make Pg interoperable w/ Oracle tools
• Netezza - MPP appliance h/w running a modded version of Pg

There are some other outfits dedicated to Pg support, but I can't recall the particulars...

Meanwhile, MySQL still seems to be having difficulty getting stored procs and real views released...5.0 is starting to make Longhorn's development schedule look like a quarterly maintenance release.

It's also interesting that TFA didn't mention the rise of alternatives ranging from SQLite (which pretty much does everything that folks used MySQL for in the first place, but wo/ any license confusion), to Firebird, to the recently open'd Ingres.