On Tue, Oct 26, 2004 at 03:10:04PM -0400, Brian Maguire wrote:
> Thanks. We do have it set to 15 mb. I would think that 16 mb would not
> make a big difference. Do you have any other ideas?
Huh? No, you have it set to 15 *segments*, each of which is 16 MB long.
Maybe setting it higher will help you, but maybe it won't, depending on
wheter there's a checkpoint run when the system is in a somewhat idle
state.
Oh, you may also want to increase checkpoint_timeout, so that
checkpoints are run less frequently.
But then, checkpoints will be run less frequently and they will take
longer. If you do have idle or low-load periods, try to run a
checkpoint when they occur. Else you may need faster disks ...
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"This is a foot just waiting to be shot" (Andrew Dunstan)
