• Andres Freund's avatar
    Skip checkpoints, archiving on idle systems. · 6ef2eba3
    Andres Freund authored
    Some background activity (like checkpoints, archive timeout, standby
    snapshots) is not supposed to happen on an idle system. Unfortunately
    so far it was not easy to determine when a system is idle, which
    defeated some of the attempts to avoid redundant activity on an idle
    system.
    
    To make that easier, allow to make individual WAL insertions as not
    being "important". By checking whether any important activity happened
    since the last time an activity was performed, it now is easy to check
    whether some action needs to be repeated.
    
    Use the new facility for checkpoints, archive timeout and standby
    snapshots.
    
    The lack of a facility causes some issues in older releases, but in my
    opinion the consequences (superflous checkpoints / archived segments)
    aren't grave enough to warrant backpatching.
    
    Author: Michael Paquier, editorialized by Andres Freund
    Reviewed-By: Andres Freund, David Steele, Amit Kapila, Kyotaro HORIGUCHI
    Bug: #13685
    Discussion:
        https://www.postgresql.org/message-id/20151016203031.3019.72930@wrigleys.postgresql.org
        https://www.postgresql.org/message-id/CAB7nPqQcPqxEM3S735Bd2RzApNqSNJVietAC=6kfkYv_45dKwA@mail.gmail.com
    Backpatch: -
    6ef2eba3
xlogfuncs.c 18.5 KB