Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group