Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ...

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ...
Дата
Msg-id
20200904144140.GA9510@alvherre.pgsql
Ответ на
Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... (Laurenz Albe)
Список
Дерево обсуждения
Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... Anna Akenteva <a.akenteva@postgrespro.ru>
Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... Tom Lane <tgl@sss.pgh.pa.us>
Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... Anna Akenteva <a.akenteva@postgrespro.ru>
Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... Laurenz Albe <laurenz.albe@cybertec.at>
Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... Laurenz Albe <laurenz.albe@cybertec.at>
Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... Laurenz Albe <laurenz.albe@cybertec.at>
Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... Laurenz Albe <laurenz.albe@cybertec.at>
Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... Alvaro Herrera <alvherre@2ndquadrant.com> 
On 2020-Sep-04, Laurenz Albe wrote:

> The value I see in this is:
> - replacing a primary key index
> - replacing the index behind a constraint targeted by a foreign key

But why is this better than using REINDEX CONCURRENTLY?

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
В списке pgsql-hackers по дате отправления
Предыдущее
От: Alvaro Herrera
Дата:
Следующее
От: Tomas Vondra
Дата:
FAQ