Re: reindexing db - Mailing list pgsql-admin

From David G. Johnston
Subject Re: reindexing db
Date
Msg-id CAKFQuwb_6QWgSmUn-G2qEqmHWU1fychQuJrOZ_bF0ofCE0a_gg@mail.gmail.com
Whole thread Raw
In response to reindexing db  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: reindexing db  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
On Mon, Dec 7, 2020 at 5:45 PM Scott Ribe <scott_ribe@elevated-dev.com> wrote:
Does reindexdb --concurrently skip over indexes for exclusion constraints, or reindex them separately without the concurrently option? The docs for reindexdb simply point one to the reindex docs for the caveats of concurrently, where that restriction is mentioned.


The REINDEX page says:

"Furthermore, indexes for exclusion constraints cannot be reindexed concurrently. If such an index is named directly in this command, an error is raised. If a table or database with exclusion constraint indexes is reindexed concurrently, those indexes will be skipped. (It is possible to reindex such indexes without the CONCURRENTLY option.)"

David J.

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: reindexing db
Next
From: Scott Ribe
Date:
Subject: Re: reindexing db