vacuum vs open transactions

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: vacuum vs open transactions
Date: 2005-01-12 17:59:17
Message-ID: 200501121059.18162.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Caduto 2005-01-12 18:00:22 Postgresql 8.0 and Cancel/Kill backend functions
Previous Message Tom Lane 2005-01-12 17:34:50 Re: Bug in pg_dump in 7.4.6?