From: James Fraley <jamesfraley@yahoo.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
To: Matthew Planchard <matthew@specprotected.com>
Subject: Re: Index recreation details with REINDEX TABLE CONCURRENTLY
Date: Wed, 10 May 2023 21:01:18 +0000 (UTC)
Message-ID: <1003715664.279699.1683752478378@mail.yahoo.com> (raw)
In-Reply-To: <87ild0p6d4.fsf@gmail.com>
References: <87ild0p6d4.fsf@gmail.com>
How do I get off this list?
Respectfully,
James Fraley
Anima Sana in Corpore Sano
On Wednesday, May 10, 2023 at 01:59:37 PM EDT, Matthew Planchard <matthew@specprotected.com> wrote:
Hello,
We're working on setting up some regular jobs to reindex tables where we
wind up generating a lot of index bloat. We're planning on using REINDEX
... CONCURRENTLY. We'd like to reindex all of the indexes on the tables.
In some of our environments, these tables are very large and under high
load, and we want to minimize the resource consumption of index
recreation if possible.
With that in mind, my question is: does REINDEX TABLE CONCURRENTLY
operate on the indexes of the table in parallel, or sequentially? If
in parallel, I imagine we would see less DB resource utilization by
updating one index at a time.
Thanks in advance for any help you can provide.
Best,
Matthew
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: jamesfraley@yahoo.com, pgsql-admin@lists.postgresql.org, matthew@specprotected.com
Subject: Re: Index recreation details with REINDEX TABLE CONCURRENTLY
In-Reply-To: <1003715664.279699.1683752478378@mail.yahoo.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