Heikki Linnakangas wrote:
> For comparison, imola-328 has full_page_writes=off. Checkpoints last ~9 
> minutes there, and the graphs look very smooth. That suggests that 
> spreading the writes over a longer time wouldn't make a difference, but 
> smoothing the rush at the beginning of checkpoint might. I'm going to 
> try the algorithm I posted, that uses the WAL consumption rate from 
> previous checkpoint interval in the calculations.

One thing that concerns me is that checkpoint smoothing happening just
after the checkpoint is causing I/O at the same time that
full_page_writes is causing additional I/O.  Ideally we would do the
smoothing toward the end of the checkpoint cycle, but I realize that has
problems of its own.

  Bruce Momjian  <[EMAIL PROTECTED]>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

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

Reply via email to