Horton

Re: [HACKERS] More detail on settings for pgavd?

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

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: josh@agliodbs.com
Cc: "Matthew T. O'Connor" <matthew@zeut.net>, Robert Treat <xzilla@users.sourceforge.net>, Shridhar Daithankar <shridhar_daithankar@myrealbox.com>, pgsql-performance@postgresql.org, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2003-11-21T23:04:56Z
Lists: pgsql-hackers, pgsql-performance 
Josh Berkus <josh@agliodbs.com> writes:
> BTW, do we have any provisions to avoid overlapping vacuums?  That is, to 
> prevent a second vacuum on a table if an earlier one is still running?

Yes, VACUUM takes a lock that prevents another VACUUM on the same table.

			regards, tom lane