Re: Vacuum, analyze, and setting reltuples of pg_class

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Vacuum, analyze, and setting reltuples of pg_class
Дата
Msg-id 13642.1165856910@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Vacuum, analyze, and setting reltuples of pg_class  ("Greg Sabino Mullane" <greg@turnstep.com>)
Ответы Re: Vacuum, analyze, and setting reltuples of pg_class  ("Greg Sabino Mullane" <greg@turnstep.com>)
Re: Vacuum, analyze, and setting reltuples of pg_class  ("Jim C. Nasby" <jim@nasby.net>)
Список pgsql-hackers
Дерево обсуждения 
"Greg Sabino Mullane" <greg@turnstep.com> writes:
> Short version: is it optimal for vacuum to always populate reltuples
> with live rows + dead rows?

If we didn't do that, it would tend to encourage the use of seqscans on
tables with lots of dead rows, which is probably a bad thing.

> Is there any way to encourage those dead rows to go away,

Close your open transactions.
        regards, tom lane

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

Предыдущее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Vacuum, analyze, and setting reltuples of pg_class
Следующее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Re: Vacuum, analyze, and setting reltuples of pg_class