vacuum vs open transactions - Mailing list pgsql-general

From Ed L.
Subject vacuum vs open transactions
Date
Msg-id 200501121059.18162.pgsql@bluepolka.net
Whole thread Raw
Responses Re: vacuum vs open transactions  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-general
I'm looking at some 7.3.4 vacuum output, and at first glance it does not
appear that vacuum is reclaiming any dead tuple space if there is even a
single open transaction, even if the open transaction does not in any way
reference the table being vacuumed.  Is that correct?  Is the behavior
different in later versions?

Ed


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug in pg_dump in 7.4.6?
Next
From: Tony Caduto
Date:
Subject: Postgresql 8.0 and Cancel/Kill backend functions