Re: 7.3.1 takes long time to vacuum table?

> -----Original Message-----
> From: Peter Childs [mailto:Blue.Dragon@blueyonder.co.uk]
> Sent: 19 February 2003 06:05
> To: PostgreSQL General
> Subject: Re: [GENERAL] 7.3.1 takes long time to vacuum table?
>


> > 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

Hi Peter,

I am running vacuum verbose, however after displaying an information
line a few hours in, it won't output any information now until the
vacuum is complete as I guess it's now just moving pages around.... :(


Cheers,

Mark.

---

Mark Cave-Ayland
Webbased Ltd.
Tamar Science Park
Derriford
Plymouth
PL6 8BX
England

Tel: +44 (0)1752 764445
Fax: +44 (0)1752 764446


This email and any attachments are confidential to the intended
recipient and may also be privileged. If you are not the intended
recipient please delete it from your system and notify the sender. You
should not copy it or use it for any purpose nor disclose or distribute
its contents to any other person.