Re: [PERFORM] Checkpointing question

2011-02-15 Thread Kevin Grittner
"Strange, John W" wrote: > During heavy writes times we get the checkpoint too often error, > what's the real knock down effect of checkpointing too often? The main concern is that it may cause an increase in disk writes, possibly to the point of causing blocking while waiting for the disk.

[PERFORM] Checkpointing question

2011-02-15 Thread Strange, John W
During heavy writes times we get the checkpoint too often error, what's the real knock down effect of checkpointing too often? The documents don't really say what is wrong with checkpointing too often, does it cause block, io contention, etc, etc? From my understanding it's just IO contention,