Re: [SQL] VACUUM and locking

2002-10-28 Thread Tom Lane
"Denise Bossarte" <[EMAIL PROTECTED]> writes: > I have looked at the documentation on locking and VACUUM and have found > conflicting reports. > http://www.postgresql.org/idocs/index.php?locking-tables.html states that > VACUUM (without FULL) acquires a ShareUpdateExclusiveLock and VACUUM with > F

[SQL] VACUUM and locking

2002-10-28 Thread Denise Bossarte
I am trying to automate VACUUMing several databases and am confused on how client connections to the database might affect the VACUUM. I have looked at the documentation on locking and VACUUM and have found conflicting reports. The 7.2.1 Documentation http://www.postgresql.org/idocs/index.php?loc