Roberts, Jon wrote: > Back to PostgreSQL, when a vacuum is issued, the old deleted rows are > removed. This can be done with the autovacuum feature or manually. > > -Does vacuum make sure there are no long running queries referencing the > deleted rows before it attempts to remove the old rows? It does. > -With autovacuum, does it skip these rows still being referenced in a > transaction or does it wait? It skips them, the idea being that a future vacuum will remove them. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
