Re: [PERFORM] pgbench - tps for Postgresql-9.0.2 is more than tps for Postgresql-8.4.1

2011-01-30 Thread Robert Haas
On Thu, Jan 27, 2011 at 2:26 PM, DM wrote: > Is there anything that i can do to still improve 9.0.2 performance. the > performance (tps) that i got is only 10% is it ideal, or should i need to > get more? Well, the settings you specified don't sound like the values that we normally recommend. ht

Re: [PERFORM] pgbench - tps for Postgresql-9.0.2 is more than tps for Postgresql-8.4.1

2011-01-27 Thread DM
Pg 9.0.2 is performing better than pg8.4.1 There are more transactions per second in pg9.0.2 than in pg8.4.1, which is a better thing. also below are kernel parameters that i used. -- Shared Memory Limits max number of segments = 4096 max seg size (kbytes) = 15099492 max total shar