Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Shouldn't we make the autovac launcher use READ COMMITTED, too?
Anything which starts a transaction and doesn't need to use a
transaction-lifetime snapshot plus SIRead locks to achieve truly
serializable behavior should probably be ignoring
default_transaction_isolation and forcing READ COMMITTED. I would
think that should include the autovac launcher. Probably *any* of
the background processes which can get a start a transaction should
force READ COMMITTED.
In response to
pgsql-hackers by date
|Next:||From: Dan Ports||Date: 2011-11-30 00:34:00|
|Subject: Re: autovacuum and default_transaction_isolation|
|Previous:||From: Joe Abbate||Date: 2011-11-30 00:29:20|
|Subject: Reserved words and delimited identifiers|