Dead rows not getting removed during vacuum

Поиск
Список
Период
Сортировка
От Granthana Biswas
Тема Dead rows not getting removed during vacuum
Дата
Msg-id CAACh-pURv74Hz9tYpp5SDaddSaMMqq=xkm9v-rNUZOC8DxFqtQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Dead rows not getting removed during vacuum  (Venkata Balaji Nagothi <vbnpgc@gmail.com>)
Re: Dead rows not getting removed during vacuum  (Sergey Konoplev <gray.ru@gmail.com>)
Re: Dead rows not getting removed during vacuum  (Haribabu Kommi <kommi.haribabu@gmail.com>)
Список pgsql-general
Дерево обсуждения
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.
The number of dead rows varies with each table.

Regards,
Granthana

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

Предыдущее
От: Bhim Kumar
Дата:
Сообщение: SQL Query for Foreign constraint
Следующее
От: Venkata Balaji Nagothi
Дата:
Сообщение: Re: Dead rows not getting removed during vacuum