Обсуждение: VACUUM ANALYZE : Is this a time consuming procedure?
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
Re: VACUUM ANALYZE : Is this a time consuming procedure?
От
"Vishal Kashyap @ [Sai Hertz And Control Systems]"
Дата:
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@yahoo.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@postgresql.org > -- With Best Regards, Vishal Kashyap. Did you know SaiPACS is one and only PACS Management tool. http://saihertz.com