hi,
our system is handling between 600 and 2000 transactions per second. all
of them are very small, very fast. typical query runs in under 1ms.
yes - sometimes we get queries that take longer than then should get.
simple check shows that we have a very visible pattern of
every-5-minutes peak.
in
On Tue, 2007-09-25 at 11:58 +0200, hubert depesz lubaczewski wrote:
hi,
our system is handling between 600 and 2000 transactions per second. all
of them are very small, very fast. typical query runs in under 1ms.
yes - sometimes we get queries that take longer than then should get.
simple
On Tue, 25 Sep 2007, hubert depesz lubaczewski wrote:
name | setting | unit
---+---+
bgwriter_all_maxpages | 5 |
bgwriter_all_percent | 0.333 | [null]
bgwriter_delay| 200 | ms
bgwriter_lru_maxpages | 5 |
Greg Smith [EMAIL PROTECTED] writes:
On Tue, 25 Sep 2007, hubert depesz lubaczewski wrote:
name | setting | unit
---+---+
bgwriter_all_maxpages | 5 |
bgwriter_all_percent | 0.333 | [null]
bgwriter_delay| 200
On Tue, 25 Sep 2007, Gregory Stark wrote:
I'm surprised you don't start by suggesting lowering bgwriter_delay for a busy
dedicated system. Does it cause too much wasted cpu work in the all cycle in
8.2?
I've just found it easier to sort through this class of problem by getting
the maxpages