Re: Repeated VACUUM reports same number of deleted rows

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Repeated VACUUM reports same number of deleted rows
Дата
Msg-id 9384.1096641729@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Repeated VACUUM reports same number of deleted rows  (Russell Smith <mr-russ@pws.com.au>)
Ответы Re: Repeated VACUUM reports same number of deleted rows
Список pgsql-general
Russell Smith <mr-russ@pws.com.au> writes:
> Should VACUUM report the rows as deleted or say they could not be deleted?
> Why does it report the same information for three runs in a row?

I see no pending deletions in that vacuum output:

> DETAIL:  0 dead row versions cannot be removed yet.

so I'm not sure why you would expect the output to change.

            regards, tom lane

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

Предыдущее
От: Kevin Barnard
Дата:
Сообщение: Re: newby question
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Bug with updateable Views and inherited tables?