• Bruce Momjian's avatar
    Delay write of pg_stats file to once every five minutes, during · 944a17bf
    Bruce Momjian authored
    shutdown, or when requested by a backend:
    
    It changes so the file is only written once every 5 minutes (changeable
    of course, I just picked something) instead of once every half second.
    It's still written when the stats collector shuts down, just as before.
    And it is now also written on backend request. A backend requests a
    rewrite by simply sending a special stats message. It operates on the
    assumption that the backends aren't actually going to read the
    statistics file very often, compared to how frequent it's written today.
    
    Magnus Hagander
    944a17bf
pgstat.h 12.7 KB