Clear questions and runnable code
get the best and fastest answer
Re^3: What is your favourite Linux or cross-platform database?by erix (Parson)
|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)
PostgreSQL 10 has logical replication (i.e., you can limit replication to only the necessary tables)
PostgreSQL 10 has much improved partitioning.