Horton

Re: [HACKERS] Autovacuum improvements

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Matthew T. O'Connor" <matthew@zeut.net>
Cc: Patches <pgsql-patches@postgresql.org>
Date: 2007-01-16T02:52:53Z
Lists: pgsql-hackers 
"Matthew T. O'Connor" <matthew@zeut.net> writes:
> Is there any chance of a race condition here?  That is, can the launcher 
> process start a new autovacuum process against that database that your 
> code will miss since it was started after you began your search?

No; we're holding a lock against incoming processes in that database.

			regards, tom lane