Re: Dead rows not getting removed during vacuum

Поиск
Список
Период
Сортировка
От Venkata Balaji Nagothi
Тема Re: Dead rows not getting removed during vacuum
Дата
Msg-id CAHBAh5tsGFm4rDsF5V_baVa1beD3JSF=rRxToPJ7hyEL_iU+Nw@mail.gmail.com
обсуждение исходный текст
Ответ на Dead rows not getting removed during vacuum  (Granthana Biswas <granthana@zedo.com>)
Ответы Re: Dead rows not getting removed during vacuum
Список pgsql-general
Дерево обсуждения
On Thu, Mar 20, 2014 at 5:27 AM, Granthana Biswas <granthana@zedo.com> wrote:

Hello All,

Has anyone ever faced the issue of dead rows not getting removed during vacuum even if there are no open transactions/connections?

We have been facing this during every scheduled vacuum which is done after closing all other database connections:

119278 dead row versions cannot be removed yet.
This means there are transactions in progress when the vacuum was running. Do you see any such situation ?

Please let us know, which version of PostgreSQL is this.

Venkata Balaji N

Sr. Database Administrator
Fujitsu Australia

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

Предыдущее
От: Granthana Biswas
Дата:
Сообщение: Dead rows not getting removed during vacuum
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Re: SQL Query for Foreign constraint