Postgres Pro
Downloads
Home   >   mailing lists

Re: how much postgres can scale up? - Mailing list pgsql-performance

From Pierre C
Subject Re: how much postgres can scale up?
Date
Msg-id op.vwu4s1y8eorkce@apollo13
Whole thread Raw
In response to how much postgres can scale up?  ("Anibal David Acosta" <aa@devshock.com>)
List pgsql-performance
Tree view 
> 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.

pgsql-performance by date:

Previous
From: Claudio Freire
Date:
Subject: Re: strange query plan with LIMIT
Next
From: Greg Smith
Date:
Subject: Re: how much postgres can scale up?