Stuck vacuum...

Поиск
Список
Период
Сортировка
От Mike Diehl
Тема Stuck vacuum...
Дата
Msg-id 200910091353.56357.mdiehl@diehlnet.com
обсуждение исходный текст
Ответы Re: Stuck vacuum...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Christophe Pettus
Дата:
Сообщение: Re: Best data type to use for sales tax percent
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: array question