• Robert Haas's avatar
    Add new buffers_backend_fsync field to pg_stat_bgwriter. · 3134d886
    Robert Haas authored
    This new field counts the number of times that a backend which writes a
    buffer out to the OS must also fsync() it.  This happens when the
    bgwriter fsync request queue is full, and is generally detrimental to
    performance, so it's good to know when it's happening.  Along the way,
    log a new message at level DEBUG1 whenever we fail to hand off an fsync,
    so that the problem can also be seen in examination of log files
    (if the logging level is cranked up high enough).
    
    Greg Smith, with minor tweaks by me.
    3134d886
monitoring.sgml 72.6 KB