• Alvaro Herrera's avatar
    Add the "recheck" logic to autovacuum worker code. The worker first builds · 7d4c9a57
    Alvaro Herrera authored
    its table list and then rechecks pgstat before vacuuming each table to
    verify that no one has vacuumed the table in the meantime.
    
    In the current autovacuum world this only means that a worker will not
    vacuum a table that a user has vacuumed manually after the worker started.
    When support for multiple autovacuum workers is introduced, this will reduce
    the probability of simultaneous workers on the same database doing redundant
    work.
    7d4c9a57
pgstat.c 63.8 KB