Re: 7.3.1 takes long time to vacuum table?

From: Peter Childs <Blue(dot)Dragon(at)blueyonder(dot)co(dot)uk>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: 7.3.1 takes long time to vacuum table?
Date: 2003-02-19 06:04:58
Message-ID: 200302190604.58782.Blue.Dragon@blueyonder.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday 19 February 2003 02:14, Martijn van Oosterhout wrote:
> On Tue, Feb 18, 2003 at 03:20:36PM -0000, Mark Cave-Ayland wrote:
> > Hi everyone,
> >

> This is probably a good argument to have VACUUM emit a notice every 10
> minutes or so giving some indication of its progress. I don't know how hard
> this would be.
>

Try Vacuum Verbose; It does not print a message out every 10 minites but it
should tell you that somthing is happerning, oh and whats happerning if you
can make any sence of the messages.....

Peter Childs

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-02-19 06:34:26 Re: TIMESTAMP WITH( OUT)? TIME ZONE indexing/type choice...
Previous Message CN 2003-02-19 05:55:30 Re: BLOB or BYTEA field