[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

Re: [GENERAL] PostgreSQL 9.0 users

2011-06-11 Thread Tom Lane
Zhidong She zhidong@gmail.com 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

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

2011-06-11 Thread Tom Lane
akp geek akpg...@gmail.com 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

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 zhidong@gmail.com wrote: Hi all, Could you please give us some typical users that already upgraded to version

Re: [GENERAL] PostgreSQL 9.0 users

2011-06-11 Thread Dmitriy Igrishin
Hey Zhidong, 2011/6/11 Zhidong She zhidong@gmail.com 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

[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

[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