[DOCS] postgres reindexing on partition table
От | Jashobanta Mahapatra |
---|---|
Тема | [DOCS] postgres reindexing on partition table |
Дата | |
Msg-id | EC7D716DA3C62341848CDCC6623FB859376CAC86@COMV-MBX02-GGN.COMVIVA.COM обсуждение исходный текст |
Список | pgsql-docs |
Hi,
Please help me on this.
We are migrating our application from Oracle to Postgres.
So we have some big tables where partitioning and indexing is implemented we are migrating into postgres.
For postgres we are rebuilding the indexes by running create concurrently, drop, alter schema inside a script.
But in case of partition table we are facing the problem as we have to know the exact index name and partition name( which may change every month) in order to rebuild index (create concurrently, drop, alter) .
Thanks a lot in advance.
jasho
В списке pgsql-docs по дате отправления: