VACUUM ANALYZE : Is this a time consuming procedure?

From: Kumar S <ps_postgres(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: VACUUM ANALYZE : Is this a time consuming procedure?
Date: 2004-11-09 20:34:47
Message-ID: 20041109203447.12723.qmail@web51406.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Vishal Kashyap @ [Sai Hertz And Control Systems] 2004-11-10 02:47:03 Re: VACUUM ANALYZE : Is this a time consuming procedure?
Previous Message Michael Fuhr 2004-11-09 18:07:25 Re: user defined type