[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    CREATE INDEX ONLY on a partitioned table?
From:       Ron <ronljohnsonjr () gmail ! com>
Date:       2021-06-29 3:53:09
Message-ID: fb17c143-ec52-b3bb-ef7c-186226127748 () gmail ! com
[Download RAW message or body]

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.


[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic