Re: document the need to analyze partitioned tables

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: document the need to analyze partitioned tables
Дата
Msg-id 1fd81ddc7710a154834030133c6fea41e55c8efb.camel@cybertec.at
обсуждение исходный текст
Ответ на Re: document the need to analyze partitioned tables  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Ответы Re: document the need to analyze partitioned tables  (Andrey Lepikhov <a.lepikhov@postgrespro.ru>)
Re: document the need to analyze partitioned tables  (Nathan Bossart <nathandbossart@gmail.com>)
Список pgsql-hackers
On Mon, 2022-03-28 at 15:05 +0200, Tomas Vondra wrote:
> I've pushed the last version, and backpatched it to 10 (not sure I'd
> call it a bugfix, but I certainly agree with Justin it's worth
> mentioning in the docs, even on older branches).

I'd like to suggest an improvement to this.  The current wording could
be read to mean that dead tuples won't get cleaned up in partitioned tables.


By the way, where are the statistics of a partitioned tables used?  The actual
tables scanned are always the partitions, and in the execution plans that
I have seen, the optimizer always used the statistics of the partitions.

Yours,
Laurenz Albe

Вложения

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Add meson.build to version_stamp.pl
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: [Commitfest 2022-09] Date is Over.