Re: VACUUM ANALYZE : Is this a time consuming procedure?

Kumar ,

Check if a query like update or insert is in progress.
Vacumm will wait unless change queries dont end.

On Tue, 9 Nov 2004 12:34:47 -0800 (PST), Kumar S <ps_postgres(at)yahoo(dot)com> wrote:
> Dear group,
>
> Is vacuum analyze a time consuming procedure. On a
> scale of 1 to 10 my database is on 4.
> Today I ran a vacuum analyze command and it is taking
> for ever. I am worried? Is some thing wrong going on
> or it usually takes time given no VACUUMing is done
> before on the database.
> Pls. suggest, if something is really wrong, I can halt
> the process.
>
> Thank,
> kumar.
>
> __________________________________
> Do you Yahoo!?
> Check out the new Yahoo! Front Page.
> www.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

--
With Best Regards,
Vishal Kashyap.
Did you know SaiPACS is one and only PACS
Management tool.
http://saihertz.com