From: Pierre C <lists@peufeu.com>
To: pgsql-performance@postgresql.org, "Anibal David Acosta" <aa@devshock.com>
Subject: Re: how much postgres can scale up?
Date: Fri, 10 Jun 2011 15:52:03 +0200
Message-ID: <op.vwu4s1y8eorkce@apollo13> (raw)
In-Reply-To: <000601cc2761$a2e3a280$e8aae780$@devshock.com>
References: <000601cc2761$a2e3a280$e8aae780$@devshock.com>
> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: lists@peufeu.com, aa@devshock.com
Subject: Re: how much postgres can scale up?
In-Reply-To: <op.vwu4s1y8eorkce@apollo13>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox