Thanks for all the replies. As of right now I think I have it narrowed down to
checkpoints based on the iostat activity I see when the hangs occur as well as
the checkpoint_timeout defaulting to 5 min.
I've upped checkpoint_warnings to 3600 to confirm but also made a few other
changes. I move
Ok, partial day results. Looks like my changes have not solved the problem,
just spread it out a little more (as would be expected based on your
responses). The delays are now shorter (about half) but occur more frequently
(maybe 1x / minute). The params I used are:
bgwriter_lru_percent = 5.
pointing a little more often with less data? (right now I hit the
checkpoint_timeout).
Thanks again,
Marc
- Original Message
From: Greg Smith <[EMAIL PROTECTED]>
To: Marc Rossi <[EMAIL PROTECTED]>
Cc: pgsql-general@postgresql.org
Sent: Friday, August 10, 2007 2:36:28 AM
Subje
