[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