Re: BUG #4059: Vacuum full not always cleaning empty tables

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Mark Steben <msteben(at)autorevenue(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4059: Vacuum full not always cleaning empty tables
Date: 2008-03-26 13:00:45
Message-ID: 20080326130045.GE5895@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Mark Steben wrote:
> Yes, there are transactions that predate the start time of the vacuum full.
> However those transactions do not touch the table being vacuumed, they have
> nothing to do with it. Is this the expected behavior?

Yes. The system has no way to know that they will not examine the table
in the future, so it has to be conservative about what it removes.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bill Moran 2008-03-26 13:22:18 Re: BUG: PG do not use index
Previous Message Mark Steben 2008-03-26 12:53:38 Re: BUG #4059: Vacuum full not always cleaning empty tables