Postgres Pro
Downloads
Home   >   mailing lists

Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ...
Date
Msg-id 20200904144140.GA9510@alvherre.pgsql
Whole thread Raw
In response to Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ...  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ...  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Division in dynahash.c due to HASH_FFACTOR
Next
From: Tomas Vondra
Date:
Subject: Re: Ideas about a better API for postgres_fdw remote estimates