Re: Problems Vacuum'ing

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problems Vacuum'ing
Дата
Msg-id 9804.1080952520@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Problems Vacuum'ing  (jseymour@LinxNet.com (Jim Seymour))
Ответы Re: Problems Vacuum'ing  (jseymour@LinxNet.com (Jim Seymour))
Re: Problems Vacuum'ing  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Список pgsql-hackers
jseymour@LinxNet.com (Jim Seymour) writes:
> Again the difference: With WebObjects running, deleting rows and
> trying to vacuum immediately, even full, fails.  Shut-down WebObjects
> and I can.

WebObjects is evidently holding an open transaction.  Ergo, anything
deleted after the start of that transaction isn't vacuumable.  You need
to do something about the client-side logic that is holding an open
transaction without doing anything ...
        regards, tom lane


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Function to kill backend
Следующее
От: Manfred Koizar
Дата:
Сообщение: Re: [GENERAL] Large DB