CREATE INDEX CONCURRENTLY on partitioned table

Поиск
Список
Период
Сортировка
От Sergey Sargsyan
Тема CREATE INDEX CONCURRENTLY on partitioned table
Дата
Msg-id CAMAof6-=D9jZyBLpbPq7FZJjtuHUtErxyOgAkBkKnVXDj=BDhw@mail.gmail.com
обсуждение исходный текст
Список pgsql-docs
Hello,
I noticed that the official documentation states that PostgreSQL does not support concurrent creation of indexes in a partitioned index.

"Concurrent builds for indexes on partitioned tables are currently not supported. However, you may concurrently build the index on each partition individually and then finally create the partitioned index non-concurrently in order to reduce the time where writes to the partitioned table will be locked out. In this case, building the partitioned index is a metadata only operation."

If I'm not mistaken, this has been the case for a long time, but the feature is currently supported. I've looked at the source code and also ran some tests, everything seems to work.




--
Sargsyan Serezha           Platform V Pangolin SE — platformv.sbertech.ru/products/rabota-s-dannymi/pangolin

В списке pgsql-docs по дате отправления: