How to tune them?
Now I have:
checkpoint_segments = 5 # in logfile segments, min 1, 16MB each
checkpoint_timeout = 900# range 30-3600, in seconds
checkpoint_warning = 30 # in seconds, 0 is off
No checkpoint warnings in pgsql logs.
On 3/27/07, Oleg Bartunov wrote:
hm
Disc write activity timeline looks like the following:
CHECKPOINT ->
Large disc write (30-40M/s), 1 second ->
4-5 seconds: no read and write activity at all, but server works slow ->
2-3 seconds: disc write activity about 4-5 M/s ->
restore normal speed
On 3/28/07, Dmitry Koterov <[EMAIL PROTEC
New information.
When I run CHECKPOINT manually in psql console, effect is fully reproduced.
So - it is a checkpoint slowdown.
The quesion is - how to make CHECKPOINT work faster?
On 3/27/07, Dmitry Koterov <[EMAIL PROTECTED]> wrote:
How to tune them?
Now I have:
checkpoint_segments = 5
hmm,
looks like checkpoint ?
Check checkpoint settings in postgresql.conf.
Oleg
On Tue, 27 Mar 2007, Dmitry Koterov wrote:
Hello.
I have found that sometimes heavy loaded PostgreSQL begins to run all the
queries slower than usual, sometimes - 5 and more times slower. I cannot
reprocude tha
Hello.
I have found that sometimes heavy loaded PostgreSQL begins to run all the
queries slower than usual, sometimes - 5 and more times slower. I cannot
reprocude that, but symptoms are the following: queries work very fast for
5-10 minutes, and after that - significant slowdown (every query, ev
