Postgres Pro
Downloads
Home   >   mailing lists

VACUUM and transactions in different databases - Mailing list pgsql-general

From Cornelia Boenigk
Subject VACUUM and transactions in different databases
Date
Msg-id 45775103.1040001@cornelia-boenigk.de
Whole thread Raw
Responses Re: VACUUM and transactions in different databases  (Bill Moran <wmoran@collaborativefusion.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Trying to Understand Table Inheritance
Next
From: Bill Moran
Date:
Subject: Re: VACUUM and transactions in different databases