From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: James Coleman <jtc331@gmail.com>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: David Johnston <david.g.johnston@gmail.com>
Cc: PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Cc: Andres Freund <andres@anarazel.de>
Subject: Re: [DOC] Document concurrent index builds waiting on each other
Date: Wed, 13 Jan 2021 14:33:43 -0300
Message-ID: <20210113173343.GA31409@alvherre.pgsql> (raw)
In-Reply-To: <CAAaqYe-P54OQOm1u+dWkD=DO7eGAdMBTSVygj_JvqDjibXih3Q@mail.gmail.com>
On 2021-Jan-13, James Coleman wrote:
> On Wed, Jan 13, 2021 at 12:58 AM Michael Paquier <michael@paquier.xyz> wrote:
> >
> > On Tue, Jan 12, 2021 at 04:51:39PM -0300, Alvaro Herrera wrote:
> > > I looked into this again, and I didn't like what I had added to
> > > maintenance.sgml at all. It seems out of place where I put it; and I
> > > couldn't find any great spots. Going back to your original proposal,
> > > what about something like this? It's just one more para in the "notes"
> > > section in CREATE INDEX and REINDEX pages, without any additions to the
> > > VACUUM pages.
> >
> > +1.
>
> I think one more para in the notes is good. But shouldn't we still
> clarify the issue is specific to CONCURRENTLY?
How is it specific to concurrent builds? What we're documenting here is
the behavior of vacuum, and that one is identical in both regular builds
and concurrent builds (since vacuum has to avoid removing rows from
under either of them). The only reason concurrent builds are
interesting is because they take longer.
What was specific to concurrent builds was the fact that you can't have
more than one at a time, and that one is what was added in 58ebe967f.
> Also that it's not just the table being indexed seems fairly significant.
This is true. So I propose
Like any long-running transaction, <command>REINDEX</command> can
affect which tuples can be removed by concurrent <command>VACUUM</command>
on any table.
--
Álvaro Herrera 39°49'30"S 73°17'W
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-hackers@postgresql.org
Cc: alvherre@alvh.no-ip.org, jtc331@gmail.com, michael@paquier.xyz, david.g.johnston@gmail.com, pgsql-hackers@lists.postgresql.org, andres@anarazel.de
Subject: Re: [DOC] Document concurrent index builds waiting on each other
In-Reply-To: <20210113173343.GA31409@alvherre.pgsql>
* 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