Re: Autovacuum improvements - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Autovacuum improvements
Date
Msg-id 18383.1168885419@sss.pgh.pa.us
Whole thread Raw
In response to Re: Autovacuum improvements  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Note that currently there's no way for a backend to know whether another
> backend is autovacuum or not.  I thought about adding a flag to PGPROC,
> but eventually considered it ugly,

No, that was exactly the way I thought we'd do it.  One thing to note is
that to avoid race conditions, the PGPROC entry has to be marked as
autovac from the instant it's inserted into the array --- with a
separate area I think you'd have difficulty avoiding the race condition.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Checkpoint request failed on version 8.2.1.
Next
From: Magnus Hagander
Date:
Subject: Re: [GENERAL] Checkpoint request failed on version 8.2.1.