pgsql: Prevent autovacuum transactions from running in serializable mod

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Prevent autovacuum transactions from running in serializable mod
Date: 2011-11-30 03:40:29
Message-ID: E1RVb25-0000ky-AR@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Prevent autovacuum transactions from running in serializable mode.

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.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/73d1bfd0b567ef9a4439be1510c12c346a064d9e

Modified Files
--------------
src/backend/postmaster/autovacuum.c | 32 +++++++++++++++++++++++++++++++-
1 files changed, 31 insertions(+), 1 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Andrew Dunstan 2011-11-30 04:03:31 Re: pgsql: Prevent autovacuum transactions from running in serializable mod
Previous Message Bruce Momjian 2011-11-30 03:35:49 pgsql: Change installation docs to mention general debugging options.