CREATE INDEX ONLY on a partitioned table? - Mailing list pgsql-general

From Ron
Subject CREATE INDEX ONLY on a partitioned table?
Date
Msg-id fb17c143-ec52-b3bb-ef7c-186226127748@gmail.com
Whole thread Raw
List 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.



pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: ALTER TABLE ... DETACH PARTITION just sitting there
Next
From: Ron
Date:
Subject: Do table-level CHECK constraints affect the query optimizer?