Re: slow queue-like empty table

Поиск
Список
Период
Сортировка
От Tobias Brox
Тема Re: slow queue-like empty table
Дата
Msg-id 20060928073636.GG14672@oppetid.no
обсуждение исходный текст
Ответ на slow queue-like empty table  (Tobias Brox <tobias@nordicbet.com>)
Ответы Re: slow queue-like empty table  (Csaba Nagy <nagy@ecircle-ag.com>)
Список pgsql-performance
[Tobias Brox - Thu at 08:56:31AM +0200]
> It really seems like some transaction is still viewing the queue, since
> it found 38k of non-removable rows ... but how do I find the pid of the
> transaction viewing the queue?  As said, the pg_locks didn't give me any
> hints ...

Dropping the table and recreating it solved the immediate problem, but
there must be some better solution than that? :-)

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

Предыдущее
От: Tobias Brox
Дата:
Сообщение: slow queue-like empty table
Следующее
От: Edoardo Ceccarelli
Дата:
Сообщение: Re: autovacuum on a -mostly- r/o table