From: Scott Ribe <scott_ribe@elevated-dev.com>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: reindexing db
Date: Mon, 7 Dec 2020 19:07:28 -0700
Message-ID: <7682F67C-0AA5-4CB7-BB46-42EAEC0C7DED@elevated-dev.com> (raw)
In-Reply-To: <CAKFQuwb_6QWgSmUn-G2qEqmHWU1fychQuJrOZ_bF0ofCE0a_gg@mail.gmail.com>
References: <292966DF-135C-4483-81A9-5027FC3C8A82@elevated-dev.com>
<CAKFQuwb_6QWgSmUn-G2qEqmHWU1fychQuJrOZ_bF0ofCE0a_gg@mail.gmail.com>
> On Dec 7, 2020, at 6:00 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
>
> 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.)"
That is the sentence I was referring to, but it does not answer my question about what reindexdb does--whether it simply calls REINDEX DATABASE ..., or has logic to deal with this.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, david.g.johnston@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: reindexing db
In-Reply-To: <7682F67C-0AA5-4CB7-BB46-42EAEC0C7DED@elevated-dev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox