| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us>, Justin Pryzby <pryzby(at)telsasoft(dot)com> |
| Cc: | Nathan Bossart <nathandbossart(at)gmail(dot)com>, Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, yuzuko <yuzukohosoya(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: document the need to analyze partitioned tables |
| Date: | 2023-01-18 09:15:18 |
| Message-ID: | fae7e128fd78965a1fa4dc9c571a9f5187d16f85.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Improve-autovacuum-doc-on-partitioned-tables.V2.patch | text/x-patch | 2.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jelte Fennema | 2023-01-18 09:35:29 | Re: [EXTERNAL] Re: [PATCH] Support using "all" for the db user in pg_ident.conf |
| Previous Message | Michael Paquier | 2023-01-18 08:50:47 | Issue with psql's create_help.pl under perlcritic |