| From: | "Nick Fankhauser" <nickf(at)ontko(dot)com> |
|---|---|
| To: | "pgsql-admin" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | long vacuum |
| Date: | 2002-03-04 17:39:39 |
| Message-ID: | NEBBLAAHGLEEPCGOBHDGKELHEHAA.nickf@ontko.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
I'm doing a vacuum on an empty database (except for the system tables). I've
loaded & deleted about 140MB of data 3 times prior to this.
Does it seem reasonable that the vacuum would take more than an hour to run?
It's currently taking all of the idle CPU time, so it's working hard at
something...
I'm running PGSQL 7.1.3 and Debian Linux 2.4.14 on an Athlon 1.4Ghz box with
512MB RAM & IDE drives.
Any thoughts appreciated- I'm trying to decide whether I should cancel the
vacuum & do an autopsy.
-NF
--------------------------------------------------------------------------
Nick Fankhauser nickf(at)ontko(dot)com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-03-04 18:46:58 | Re: something similar to explain |
| Previous Message | Joe Conway | 2002-03-04 17:28:35 | Re: [GENERAL] Which trigger execute which function? |