Re: document the need to analyze partitioned tables

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: document the need to analyze partitioned tables
Дата
Msg-id fae7e128fd78965a1fa4dc9c571a9f5187d16f85.camel@cybertec.at
обсуждение исходный текст
Ответ на Re: document the need to analyze partitioned tables  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: document the need to analyze partitioned tables  (Justin Pryzby <pryzby@telsasoft.com>)
Re: document the need to analyze partitioned tables  (Bruce Momjian <bruce@momjian.us>)
Re: document the need to analyze partitioned tables  (David Rowley <dgrowleyml@gmail.com>)
Список pgsql-hackers
On Tue, 2023-01-17 at 16:16 -0500, Bruce Momjian wrote:
> On Tue, Jan 17, 2023 at 03:00:50PM -0600, Justin Pryzby wrote:
> > Maybe (all?) the clarification the docs need is to say:
> > "Partitioned tables are not *themselves* processed by autovacuum."
>
> Yes, I think the lack of autovacuum needs to be specifically mentioned
> since most people assume autovacuum handles _all_ statistics updating.
>
> Can someone summarize how bad it is we have no statistics on partitioned
> tables?  It sounds bad to me.

Andrey Lepikhov had an example earlier in this thread[1].  It doesn't take
an exotic query.

Attached is a new version of my patch that tries to improve the wording.

Yours,
Laurenz Albe

 [1]: https://postgr.es/m/3df5c68b-13aa-53d0-c0ec-ed98e6972e2e%40postgrespro.ru

Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Issue with psql's create_help.pl under perlcritic
Следующее
От: Jelte Fennema
Дата:
Сообщение: Re: [EXTERNAL] Re: [PATCH] Support using "all" for the db user in pg_ident.conf