• Tom Lane's avatar
    Prevent autovacuum transactions from running in serializable mode. · 73d1bfd0
    Tom Lane authored
    Force the transaction isolation level to READ COMMITTED in autovacuum
    worker and launcher processes.  There is no benefit to using a higher
    isolation level, and doing so could result in delaying foreground
    transactions (or maybe even causing unnecessary serialization failures?).
    Noted by Dan Ports.
    
    Also, make sure we disable zero_damaged_pages and statement_timeout in
    the autovac launcher, not only workers.  Now that the launcher can run
    transactions, these settings could affect its behavior, and it seems
    like the same arguments apply to the launcher as the workers.
    73d1bfd0
autovacuum.c 83.7 KB