On Mar 6, 2007, at 10:11 PM, ITAGAKI Takahiro wrote:
I have some results that if we have plenty of time for checkpoints, bgwriter_all_maxpages is not a so important parameter because it is adjusted to "shared_buffers / duration of checkpoint". Also, my recommended bgwriter_lru_maxpages is "average number of recycled buffers per cycle", that is hardly able to tune manually.
What do you mean by 'number of recycled buffers per cycle"? -- Jim Nasby [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
