From: Pierre Frédéric Caillaud <lists@peufeu.com>
To: Bob Dusek <redusek@gmail.com>
To: Ivan Voras <ivoras@freebsd.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: performance config help
Date: Tue, 12 Jan 2010 00:53:29 +0100
Message-ID: <op.u6d7bfnucke6l8@soyouz> (raw)
In-Reply-To: <61039b861001111057t6443b526pdc312ff2717d6227@mail.gmail.com>
References: <61039b861001110544o2c352763q13dcf9d78a156714@mail.gmail.com>
<dcc563d11001110550s2af6d559l5db495d5e0fc6a57@mail.gmail.com>
<61039b861001110842g15bb1f26jc50b6e6762e01427@mail.gmail.com>
<hifm6q$dp8$1@ger.gmane.org>
<61039b861001111057t6443b526pdc312ff2717d6227@mail.gmail.com>
> Each of the 256 requests was being processed by a php process. So, it
> could
> certainly be faster. But, the fact that we're seeing the db performance
> degrade would seem to indicate that our application is fast enough to
> punish
> the db. Isn't that true?
Not necessarily. Your DB still has lots of idle CPU, so perhaps it's your
client which is getting over the top. Or you have locking problems in your
DB.
Things to test :
- vmstat on the benchmark client
- iptraf on the network link
- monitor ping times between client and server during load test
Some time ago, I made a benchmark simulating a forum. Postgres was
saturating the gigabit ethernet between server and client...
If those PHP processes run inside Apache, I'd suggest switching to
lighttpd/fastcgi, which has higher performance, and uses a limited,
controllable set of PHP processes (and therefore DB connections), which in
turn uses much less memory.
PS : try those settings :
fsync = fdatasync
wal_buffers = 64MB
walwriter_delay = 2ms
synchronous commits @ 1 s delay
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, redusek@gmail.com, ivoras@freebsd.org
Subject: Re: performance config help
In-Reply-To: <op.u6d7bfnucke6l8@soyouz>
* 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