Re: CREATE INDEX CONCURRENTLY on partitioned index

From: Alexander Pyhalov <a(dot)pyhalov(at)postgrespro(dot)ru>
To: Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, 李杰(慎追) <adger(dot)lj(at)alibaba-inc(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org, 曾文旌(义从) <wenjing(dot)zwj(at)alibaba-inc(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Subject: Re: CREATE INDEX CONCURRENTLY on partitioned index
Date: 2022-03-02 07:24:59
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


I've added 0005-Mark-intermediate-partitioned-indexes-as-valid.patch
which fixed the following issues - when partitioned index is created,
indexes on intermediate partitioned tables were preserved in invalid
state. Also added some more tests.
Best regards,
Alexander Pyhalov,
Postgres Professional

Attachment Content-Type Size
v2-0001-Allow-CREATE-INDEX-CONCURRENTLY-on-partitioned-table.patch text/x-diff 15.3 KB
v2-0002-Add-SKIPVALID-flag-for-more-integration.patch text/x-diff 3.9 KB
v2-0003-Try-to-fix-create-index-progress-report.patch text/x-diff 7.7 KB
v2-0004-ReindexPartitions-to-set-indisvalid.patch text/x-diff 2.4 KB
v2-0005-Mark-intermediate-partitioned-indexes-as-valid.patch text/x-diff 8.3 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Masahiko Sawada 2022-03-02 07:34:59 Re: Add the replication origin name and commit-LSN to logical replication worker errcontext
Previous Message Michael Paquier 2022-03-02 07:15:15 Re: pg_stat_get_replication_slot and pg_stat_get_subscription_worker incorrectly marked as proretset