Search Postgresql Archives

Stuck vacuum...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux