Re: analyze-in-stages post upgrade questions

Поиск
Список
Период
Сортировка
От Mircea Cadariu
Тема Re: analyze-in-stages post upgrade questions
Дата
Msg-id a018a729-9b18-444f-baed-be0d6d8ecb80@gmail.com
обсуждение исходный текст
Ответ на Re: analyze-in-stages post upgrade questions  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список 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 по дате отправления: