VACUUM and transactions in different databases

From: Cornelia Boenigk <c(at)cornelia-boenigk(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: VACUUM and transactions in different databases
Date: 2006-12-06 23:23:47
Message-ID: 45775103.1040001@cornelia-boenigk.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all

If I have a running transaction in database1 and try to vacuum database2
but the dead tuples in database2 cannot be removed.

INFO: vacuuming "public.dummy1"
INFO: "dummy1": found 0 removable, 140000 nonremovable row versions in
1341 pages
DETAIL: 135000 dead row versions cannot be removed yet.

How can I achieve that database2 is vacuumed while a transaction in
database1 is not yet commited?

Regards
conni

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2006-12-06 23:28:01 Re: Trying to Understand Table Inheritance
Previous Message Tom Lane 2006-12-06 23:05:34 Re: Update Perrformance with nested loop vs. merge-join