Friday, July 20, 2007

PostgreSQL: Fast enough?

The message I get from the recent benchmark tests pitting PostgreSQL against Oracle ...

Open Source PostgreSQL Trails Oracle In Benchmark, But Not By Much

... is that PostgreSQL is quite fast enough for any application except in the most extreme situations. So, design your schema and build your system and deploy it on PostgreSQL. If your application turns out to have one of the less than 1% of all databases that need the kind of performance provided by an Oracle (or a DB2) you can take your SQL and run it on Oracle instead, once you have parted with a large wad of cash that is.

I reckon paying for a DBMS license is one of the most common and expensive forms of premature optimisation in the IT industry today.

No comments: