Re: autovacuum process blocks without reporting a deadlock

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: autovacuum process blocks without reporting a deadlock
Дата
Msg-id 29175.1195881604@sss.pgh.pa.us
обсуждение исходный текст
Ответ на autovacuum process blocks without reporting a deadlock  ("Thomas Chille" <thomas.chille@gmail.com>)
Ответы Re: autovacuum process blocks without reporting a deadlock
Список pgsql-general
"Thomas Chille" <thomas.chille@gmail.com> writes:
> One Autovacuum process stuck in the middle of the night and it seemed
> that it compete with another Select process for an index:

> [14391 / 2007-11-21 00:52:14 CET]DEBUG:  00000: index
> "hst_timerecording_id_timerecording_idx" now contains 8537 row
> versions in 61 pages

What other indexes does that table have?

            regards, tom lane

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

Предыдущее
От: Eric Davies
Дата:
Сообщение: manipulating HeapTuples in a libpq client
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: manipulating HeapTuples in a libpq client