| 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 |
| Message-ID: | 6d81c5803efb9a69cd543bb08728eeb6@postgrespro.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi.
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 |
| 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 |