Re: Vacuum runs in a loop?

On Mon, 2003-09-15 at 19:47, Tom Lane wrote:

> It seems odd though that the indexes report "Deleted 0" each time.
>
> > INFO:  Index i_flowdata_dst_as: Pages 171123; Tuples 23875181: Deleted
> > 0.
> >         CPU 10.78s/14.52u sec elapsed 831.52 sec.
>
> Normally I'd expect the index deleted count to agree with the number of
> tuples removed from the underlying table in each pass:
>
> > INFO:  Removed 1397825 tuples in 21505 pages.
> >         CPU 2.36s/2.65u sec elapsed 73.53 sec.
>
> These wouldn't happen to be partial indexes would they?  If they're
> partial, and would not have had entries for the rows you are cleaning
> out, then the behavior makes sense to me.  Otherwise there's something
> weird going on.
>
> The indexes seem a tad bloated compared to the underlying file size
> anyway.  Maybe you should REINDEX them.
>
>             regards, tom lane
>
Weird! After dropping the indexes, a lot of disk space became free!
I vacuum the table now and re-create the indexes.

Thanx Tom!

> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


Cheers!
Wim De Hul
------------------------------------------------------------------------------
IP SERVICES SPECIALIST
Belgacom Carrier and Wholesale Business Unit (CBU)
------------------------------------------------------------------------------
AS6774
Ripe : WDH25-RIPE
reply-to : NOC{at}belbone{dot}be
peering : peering{at}belbone{dot}be
NOC Tel : +32 2/547.51.00
www.belgacom.be/carrier
------------------------------------------------------------------------------
I want to die quietly in my sleep, like my grandfather.
Not screaming in terror, like his passengers.
------------------------------------------------------------------------------
8:21pm up 6 days, 8:08, 1 user, load average: 1.15, 1.08, 1.14