Re: analyze-in-stages post upgrade questions

[moving to pgsql-hackers]
On Thu, 2025-07-10 at 17:20 +0100, Mircea Cadariu wrote:
> I have only one suggestion for the patch. Consider adding a
> corresponding test in src/bin/scripts/t/100_vacuumdb.pl.
>
> Proposal (I used this to check the patch):
>
> $node->safe_psql('postgres',
>     "CREATE TABLE parent_table (a INT) PARTITION BY LIST (a);\n"
>       . "CREATE TABLE child_table PARTITION OF parent_table FOR VALUES
> IN (1);\n"
>       . "INSERT INTO parent_table VALUES (1);\n");
> $node->issues_sql_like(
>     [
>         'vacuumdb', '--analyze-only', 'postgres'
>     ],
>     qr/statement:\s+ANALYZE\s+public\.parent_table/s,
>     '--analyze_only updates statistics for partitioned tables');

Good idea; done in the attached version 2 of the patch.

Yours,
Laurenz Albe