> When 1 client connected postgres do 180 execution per second
This is suspiciously close to 10.000 executions per minute.
You got 10k RPM disks ?
How's your IO system setup ?
Try setting synchronous_commit to OFF in postgresql.conf and see if that
changes the results. That'll give useful information.
In response to
pgsql-performance by date
|Next:||From: Claudio Freire||Date: 2011-06-10 15:22:28|
|Subject: Re: strange query plan with LIMIT|
|Previous:||From: Pierre C||Date: 2011-06-10 13:52:03|
|Subject: Re: how much postgres can scale up?|