Dead rows not getting removed during vacuum

Поиск

Список

Период

Сортировка

От	Granthana Biswas
Тема	Dead rows not getting removed during vacuum
Дата	20 марта 2014 г. 21:36:50
Msg-id	CAACh-pURv74Hz9tYpp5SDaddSaMMqq=xkm9v-rNUZOC8DxFqtQ@mail.gmail.com обсуждение исходный текст
Ответы	Re: Dead rows not getting removed during vacuum Re: Dead rows not getting removed during vacuum Re: Dead rows not getting removed during vacuum
Список	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 по дате отправления: