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

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Mark Steben <msteben(at)autorevenue(dot)com>
Cc: Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #4059: Vacuum full not always cleaning empty tables
Date: 2008-03-27 20:42:01
Message-ID: 20080327204201.GC16878@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Mark Steben wrote:

> [Mark Steben] Sorry for pressing the point, just making sure I
>
> understand what you're saying.
>
> So, the only way to ensure that a vacuum full will clean out
> an
>
> Empty table is to run it on a stand-alone server?

No -- the other alternative is to wait long enough for those other
transactions to go away.

--
Alvaro Herrera http://www.amazon.com/gp/registry/CTMLCN8V17R4
"La primera ley de las demostraciones en vivo es: no trate de usar el sistema.
Escriba un guión que no toque nada para no causar daños." (Jakob Nielsen)

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-03-27 20:48:38 Re: BUG #4068: Failed to compile 8.3.1
Previous Message Alvaro Herrera 2008-03-27 20:40:42 Re: BUG #4068: Failed to compile 8.3.1