Re: analyze-in-stages post upgrade questions - Mailing list pgsql-hackers

From Laurenz Albe
Subject Re: analyze-in-stages post upgrade questions
Date
Msg-id 2c1f1834107045dfa8b32417771b56bab0cffc56.camel@cybertec.at
Whole thread Raw
Responses Re: analyze-in-stages post upgrade questions
List pgsql-hackers
[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

Attachment

pgsql-hackers by date:

Previous
From: Shinya Kato
Date:
Subject: Re: vacuumlazy: Modernize count_nondeletable_pages
Next
From: Bernd Helmle
Date:
Subject: Re: What is a typical precision of gettimeofday()?