| From: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
|---|---|
| To: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
| Cc: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Mircea Cadariu <cadariu(dot)mircea(at)gmail(dot)com>, "Zechman, Derek S" <Derek(dot)S(dot)Zechman(at)snapon(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: analyze-in-stages post upgrade questions |
| Date: | 2025-08-21 01:51:16 |
| Message-ID: | aKZ7lMYGnnIo35c0@pryzbyj2023 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
When analyzing a partitioned table, I think you should use ANALYZE ONLY,
or otherwise avoid processing the children twice.
Thanks for handling this. I was recently suprised to learn that
vacuumdb doesn't process parents.
--
Justin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dominique Devienne | 2025-08-21 08:11:08 | Re: Domains vs data types |
| Previous Message | Adrian Klaver | 2025-08-20 23:00:42 | Re: MS SQL to Postgres |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrey Borodin | 2025-08-21 02:07:16 | Re: VM corruption on standby |
| Previous Message | Peter Smith | 2025-08-21 01:10:24 | Re: Remove redundant assignment of a variable in function AlterPublicationTables |