[GENERAL] PostgreSQL 9.0 users

2011-06-11 Thread Zhidong She
Hi all, Could you please give us some typical users that already upgraded to version 9.0? We have a debate internally on choosing 8.4 or 9.0 as our product backend database. And if you have any performance benchmark result, I will highly appreciate. Many thanks, sheldon -- Sent via pgsql-gener

Re: [GENERAL] PostgreSQL 9.0 users

2011-06-11 Thread Tom Lane
Zhidong She writes: > We have a debate internally on choosing 8.4 or 9.0 as our product > backend database. Well, if it's about stability, a look at the commit logs will convince you that 9.0 and 8.4 branches are now about on par for bug fix rate. Since 9.0.4, I count 34 non-documentation patches

Re: [GENERAL] setting up streaming error. Please help

2011-06-11 Thread Tom Lane
akp geek writes: > After making the required changes to the Primary and slave , I have > restarted the slave and I keep seeing the following in the logs. > *FATAL: could not connect to the primary server: invalid connection option > "replication"* That message has to be caused by libpq

Re: [GENERAL] PostgreSQL 9.0 users

2011-06-11 Thread Carlos Mennens
I don't have bench marks but upgraded from 8.4 to 9.0 and it works perfect. No performance issues or problems but I highly recommend 9.0.4! On Jun 11, 2011 6:56 AM, "Zhidong She" wrote: > Hi all, > > Could you please give us some typical users that already upgraded to > version 9.0? > We have a de

Re: [GENERAL] PostgreSQL 9.0 users

2011-06-11 Thread Dmitriy Igrishin
Hey Zhidong, 2011/6/11 Zhidong She > Hi all, > > Could you please give us some typical users that already upgraded to > version 9.0? > We have a debate internally on choosing 8.4 or 9.0 as our product > backend database. > > We are switched our current development from 9.0 to 9.1 beta already wi

[GENERAL] Temporal database design with a twist (hard question)

2011-06-11 Thread Denis de Bernardy
I'm looking into implementing object-versioning with the added twist of needing to have both live and draft objects, and could use the insights from someone experience in this, as I'm beginning to wonder if it's even possible without potentially horrific hacks. I'll break it down to posts with

[GENERAL] benchmark comparing different postgresql versions

2011-06-11 Thread Ivan Sergio Borgonovo
Is there a place where I can find comparison in performances of different postgresql versions, hopefully related to new feature/improvements? thanks -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to you