Problems Involving Checkpoints

If the value specified for the checkpoint interval either as an initialization parameter or in the TO clause of a COPY statement is too small, it can significantly reduce transmission speed. Since the purpose of checkpointing is to save time in a restart, it is usually unnecessary to have a checkpoint interval that translates to less than a second of transmission time. A checkpoint interval that translates to 5 seconds of transmission time between checkpoints is normally more than adequate. For example, if the transmission rate to the other node is typically 10 MB/second, and you desire to lose no more than 5 seconds of transmission time in a restart, then you would set CKPT=50M.