CREATE INDEX ONLY on a partitioned table?

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: CREATE INDEX ONLY on a partitioned table?
Date: 2021-06-29 03:53:09
Message-ID: fb17c143-ec52-b3bb-ef7c-186226127748@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Postgresql 12.5.

https://www.postgresql.org/docs/12/ddl-partitioning.html mentions creating
indices on children, and then attaching them to a table which previously had
CREATE INDEX ... ONLY ON executed.

Can I do something similar on an existing table (for example, on a heavily
partitioned table, or because I want to see that progress is being made)?

--
Angular momentum makes the world go 'round.

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2021-06-29 15:10:21 Do table-level CHECK constraints affect the query optimizer?
Previous Message Laurenz Albe 2021-06-29 01:50:26 Re: ALTER TABLE ... DETACH PARTITION just sitting there