vacuum analyze takes long time

From: Hemapriya <priyam_1121(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: vacuum analyze takes long time
Date: 2004-12-10 16:51:28
Message-ID: 20041210165129.51235.qmail@web21326.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I have updated 10M rows in a table. i ran the vacuum
analyze. it has been running more than a day.

I'm not sure whether it would take so long?

total volume in the table - 16M rows

Can anyone please confirm...

thanks
Priya


__________________________________
Do you Yahoo!?
Send holiday email and support a worthy cause. Do good.
http://celebrity.mail.yahoo.com

Browse pgsql-admin by date

  From Date Subject
Next Message Chris White (cjwhite) 2004-12-10 19:52:00 Issue with large objects
Previous Message Mª José Sempere 2004-12-10 12:33:44 digest as IMMUTABLE function