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

From Mircea Cadariu
Subject Re: analyze-in-stages post upgrade questions
Date
Msg-id a018a729-9b18-444f-baed-be0d6d8ecb80@gmail.com
Whole thread Raw
In response to Re: analyze-in-stages post upgrade questions  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Hi Laurenz,


Got it. 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');


Kind regards,

Mircea Cadariu




pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Lock timeout in commit
Next
From: Adrian Klaver
Date:
Subject: Re: Aggregate versions of hashing functions (md5, sha1, etc...)