Re: how much postgres can scale up?

From: "Pierre C" <lists(at)peufeu(dot)com>
To: pgsql-performance(at)postgresql(dot)org, "Anibal David Acosta" <aa(at)devshock(dot)com>
Subject: Re: how much postgres can scale up?
Date: 2011-06-10 13:57:25
Message-ID: op.vwu41zomeorkce@apollo13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> 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

Browse pgsql-performance by date

  From Date Subject
Next Message Claudio Freire 2011-06-10 15:22:28 Re: strange query plan with LIMIT
Previous Message Pierre C 2011-06-10 13:52:03 Re: how much postgres can scale up?