Re: analyze-in-stages post upgrade questions

Justin Pryzby <pryzby@telsasoft.com>

From: Justin Pryzby <pryzby@telsasoft.com>

To: Fujii Masao <masao.fujii@gmail.com>

Cc: Laurenz Albe <laurenz.albe@cybertec.at>, Mircea Cadariu <cadariu.mircea@gmail.com>, "Zechman, Derek S" <Derek.S.Zechman@snapon.com>, Adrian Klaver <adrian.klaver@aklaver.com>, pgsql-hackers@lists.postgresql.org

Date: 2025-08-21T01:51:16Z

Lists: 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

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

vacuumdb: Make vacuumdb --analyze-only process partitioned tables.
- 6429e5b771db 19 (unreleased) landed
Integrate FullTransactionIds deeper into two-phase code
- 62a17a92833d 19 (unreleased) cited