Re: Why not represent "never vacuumed" accurately wrt pg_class.relpages?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Why not represent "never vacuumed" accurately wrt pg_class.relpages?
Дата
Msg-id 4607.1544554795@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Why not represent "never vacuumed" accurately wrtpg_class.relpages?  (Andres Freund <andres@anarazel.de>)
Ответы Re: Why not represent "never vacuumed" accurately wrtpg_class.relpages?  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Дерево обсуждения 
Andres Freund <andres@anarazel.de> writes:
> How's being unable to distinguish "never vacuumed" from "table is
> knowingly empty right now" not constrained by the representation?

Well, OK, it is constrained, but even if it weren't I'd be afraid to
assume a table is totally empty, even if it was so the last time
ANALYZE looked at it.  The plans you get from that are spectacularly
fragile.

            regards, tom lane

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Why not represent "never vacuumed" accurately wrtpg_class.relpages?
Следующее
От: Chapman Flack
Дата:
Сообщение: Re: Record last password change