Re: More VACUUM output?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dmitry Tkach <dmitry(at)openratings(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: More VACUUM output?
Date: 2003-06-13 01:38:42
Message-ID: 22303.1055468322@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dmitry Tkach <dmitry(at)openratings(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dima Tkach 2003-06-13 01:46:44 Re: Query planner question
Previous Message Tom Lane 2003-06-13 01:09:40 Re: LC_COLLATE=es_MX in PgSQL 7.3.2