Re: CREATE INDEX CONCURRENTLY on partitioned index

Alexander Pyhalov <a.pyhalov@postgrespro.ru>

From: Alexander Pyhalov <a.pyhalov@postgrespro.ru>

To: Justin Pryzby <pryzby@telsasoft.com>

Cc: Masahiko Sawada <sawada.mshk@gmail.com>, Michael Paquier <michael@paquier.xyz>, 李杰(慎追) <adger.lj@alibaba-inc.com>, pgsql-hackers@lists.postgresql.org, 曾文旌(义从) <wenjing.zwj@alibaba-inc.com>, Alvaro Herrera <alvherre@2ndquadrant.com>

Date: 2022-03-02T07:24:59Z

Lists: pgsql-hackers

Attachments

v2-0001-Allow-CREATE-INDEX-CONCURRENTLY-on-partitioned-table.patch (text/x-diff) patch v2-0001
v2-0002-Add-SKIPVALID-flag-for-more-integration.patch (text/x-diff) patch v2-0002
v2-0003-Try-to-fix-create-index-progress-report.patch (text/x-diff) patch v2-0003
v2-0004-ReindexPartitions-to-set-indisvalid.patch (text/x-diff) patch v2-0004
v2-0005-Mark-intermediate-partitioned-indexes-as-valid.patch (text/x-diff) patch v2-0005

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

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix assertion failure with REINDEX and event triggers
- c426f7c2b36a 17.0 cited