|Think about Loose Coupling|
Re^3: What is your favourite Linux or cross-platform database?by erix (Vicar)
|on Mar 30, 2010 at 16:02 UTC||Need Help??|
IMHO, that (2007) postgresql-'gotchas' webpage is not very useful anymore: almost all of these so-called 'gotchas' were relevant only to pretty old versions of Pg.
Here is a list of release dates:
pg version 7.4: 2003 pg version 8.0: 2005 pg version 8.1: 2005 pg version 8.2: 2006 pg version 8.3: 2008 pg version 8.4: 2009
Running a version older than 8.3 is rarely necessary.
Re: comparison PostgreSQL - Oracle: important things that are missing or not good enough in current (=8.4) postgresql:
Then again, compared to Oracle, PostgreSQL is much more immune to over-deployment ;-)
PostgreSQL now has native replication (both asynchronous and synchronous (it cannot do synchronous multimaster).
In-place upgrade is also now provided.
Partitioning remains a somewhat weak point. (although it works well enough for many common scenarios)