| From: | Mike Diehl <mdiehl(at)diehlnet(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Stuck vacuum... |
| Date: | 2009-10-09 19:53:56 |
| Message-ID: | 200910091353.56357.mdiehl@diehlnet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all.
I'm doing a routine vacuum on my database and it seems to be getting "stuck."
I've got a "servers" table with only a few rows and columns in it and this is
what vacuum has to say:
# VACUUM ANALYZE VERBOSE servers;
INFO: vacuuming "public.servers"
INFO: scanned index "servers_id" to remove 19200 row versions
DETAIL: CPU 0.02s/0.01u sec elapsed 0.03 sec.
INFO: scanned index "servers_name" to remove 19200 row versions
DETAIL: CPU 0.03s/0.01u sec elapsed 0.05 sec.
The problem is that it's been stalled for several minutes. It's beginning to
sound like a hard drive problem. Any other ideas?
--
Take care and have fun,
Mike Diehl.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Kretschmer | 2009-10-09 20:17:03 | Re: array question |
| Previous Message | Christophe Pettus | 2009-10-09 19:36:04 | Re: Best data type to use for sales tax percent |