Re: splitting src/bin/scripts/vacuumdb.c - Mailing list pgsql-hackers

From Álvaro Herrera
Subject Re: splitting src/bin/scripts/vacuumdb.c
Date
Msg-id 202509261350.nnoidrv2ryaf@alvherre.pgsql
Whole thread Raw
In response to Re: splitting src/bin/scripts/vacuumdb.c  (Antonin Houska <ah@cybertec.at>)
List pgsql-hackers
On 2025-Sep-26, Antonin Houska wrote:

> I agree that redundant information makes things more difficult to
> think about. I just wonder if
> 
>     vacopts->mode != MODE_VACUUM
> 
> should be used instead of
> 
>     (vacopts->mode == MODE_ANALYZE ||
>     vacopts->mode == MODE_ANALYZE_IN_STAGES)

I don't think so, because it'd become
   (vacopts->mode != MODE_VACUUM && vacopts->mode != MODE_REPACK)
after we introduce repack, which looks worse.

I considered introducing a simple macro for this usage, something like
#define  ModeIsAnalyze(mode)  (mode == MODE_ANALYZE || mode == MODE_ANALYZE_IN_STAGES)
but thought it'd be overkill.

> Other than that, I checked differences between v21, v22 and v23. I've got no
> other comments worth posting.

Thanks for looking!

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"Pido que me den el Nobel por razones humanitarias" (Nicanor Parra)



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Batching in executor
Next
From: Timur Magomedov
Date:
Subject: Re: [WIP]Vertical Clustered Index (columnar store extension) - take2