Re: 8.3.5 broken after power fail

Поиск
Список
Период
Сортировка
От Michael Monnerie
Тема Re: 8.3.5 broken after power fail
Дата
Msg-id fe4cce035058b221792530396472c362@webmail.zmi.at
обсуждение исходный текст
Ответ на Re: 8.3.5 broken after power fail  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Ответы Re: 8.3.5 broken after power fail  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Список pgsql-admin
"Achilleas Mantzios" <achill@matrix.gatewaynet.com> schrieb:
> did you reindex pg_toast_1281127?
> take a look at
> http://archives.free.net.ph/message/20080924.191644.d692f468.el.html

REINDEX TABLE pg_toast.pg_toast_1281127;

That runs now since 33 CPU minutes, using 100% with no visible I/O
happening. top says:
29687 postgres  20   0  605m 187m 3024 R  100 15.4  32:58.65 postmaster

And "strace -p 29687" displays nothing. Could it be the process hangs? It
shouldn't take that long I guess, but I'm not sure how to find out if it's
borked or really working... ideas?

mfg zmi



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

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: Re: 8.3.5 broken after power fail
Следующее
От: Achilleas Mantzios
Дата:
Сообщение: Re: 8.3.5 broken after power fail