Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #4059: Vacuum full not always cleaning empty tables - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #4059: Vacuum full not always cleaning empty tables
Date
Msg-id 20080326130045.GE5895@alvh.no-ip.org
Whole thread Raw
In response to Re: BUG #4059: Vacuum full not always cleaning empty tables  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From:
Date:
Subject: Re: BUG: PG do not use index
Next
From: "Mark Steben"
Date:
Subject: Re: BUG #4059: Vacuum full not always cleaning empty tables