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: 2026-06-04T17:14:34Z

Lists: pgsql-hackers

Checking back.

On Wed, Aug 20, 2025 at 08:51:16PM -0500, Justin Pryzby wrote:
> 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.

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