By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,710 Members | 1,960 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,710 IT Pros & Developers. It's quick & easy.

checkpoints

P: n/a
We are starting to ramp-up testing of our application, and we started getting these messages in our log file:

LOG: checkpoints are occurring too frequently (15 seconds apart)
HINT: Consider increasing the configuration parameter "checkpoint_segments".
LOG: recycled transaction log file "0000000000000045"
LOG: recycled transaction log file "0000000000000046"
LOG: recycled transaction log file "0000000000000044"

So I gather that we should bump up the number for checkpoint_segments, but I'm wondering:

1) what is reasonable rule-of-thumb for what this value should be? (we are at the default right now)
2) should checkpoint_timeout be changed at the same time?
3) should I increase wal_buffers in conjunction with checkpoint_segments?

Thanks!

- DAP
----------------------------------------------------------------------------------
David Parker Tazz Networks (401) 709-5130
*

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.