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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
