Re: pg_class.reltuples not reset by VACUUM?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_class.reltuples not reset by VACUUM?
Дата
Msg-id 15397.1049824333@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_class.reltuples not reset by VACUUM?  (Jeff Boes <jboes@nexcerpt.com>)
Ответы Re: pg_class.reltuples not reset by VACUUM?  (Jeff Boes <jboes@nexcerpt.com>)
Список pgsql-admin
Jeff Boes <jboes@nexcerpt.com> writes:
> I thought that VACUUM ANALYZE would always restore some sense of reality
> to the internal statistics for a table.  However ...

Could we see the output of VACUUM VERBOSE for that table?

I suspect you have lots of dead-but-not-yet-reclaimable tuples in the
table, presumably because there is some very old transaction lurking
in the background.

            regards, tom lane


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

Предыдущее
От: Jeff Boes
Дата:
Сообщение: VACUUM slow on small table
Следующее
От: Jeff Boes
Дата:
Сообщение: Re: pg_class.reltuples not reset by VACUUM?