should CREATE INDEX ON partitioned_table callPreventInTransactionBlock() ?

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема should CREATE INDEX ON partitioned_table callPreventInTransactionBlock() ?
Дата
Msg-id 20200608093553.GN22473@telsasoft.com
обсуждение исходный текст
Ответы Re: should CREATE INDEX ON partitioned_table callPreventInTransactionBlock() ?  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
This blocks writes to all partitions until commit:

postgres=# begin; CREATE INDEX ON pt(i);
BEGIN
CREATE INDEX

Compare with CLUSTER rel1, rel2, ..., and REINDEX {SCHEMA|DATABASE|SYSTEM},
which release their locks as soon as each rel is processed.

I noticed while implementing REINDEX for partitioned tables, which, it seems
clear, should also avoid slowly accumulating more and more write locks across
an entire partition heirarchy.

-- 
Justin



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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: Bump default wal_level to logical
Следующее
От: ahsan hadi
Дата:
Сообщение: Re: Improving psql slash usage help message