Re: More VACUUM output? - Mailing list pgsql-general

From Tom Lane
Subject Re: More VACUUM output?
Date
Msg-id 22303.1055468322@sss.pgh.pa.us
Whole thread Raw
In response to More VACUUM output?  (Dmitry Tkach <dmitry@openratings.com>)
List pgsql-general
Dmitry Tkach <dmitry@openratings.com> writes:
> What does this mean? Has it started over? Why?

No, it's just taking the dead tuples it's got so far and deleting them
from the indexes.  It does that whenever it's got VACUUM_MEM worth of
dead tuples collected.  You might be able to make things go a little
faster by increasing VACUUM_MEM ... but I wouldn't recommend aborting
the job at this point.

> Is it ever going to finish?

Looks like it's making progress to me.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: LC_COLLATE=es_MX in PgSQL 7.3.2
Next
From: Stephan Szabo
Date:
Subject: Re: Query planner question