Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group