Index recreation details with REINDEX TABLE CONCURRENTLY

From: Matthew Planchard <matthew(at)specprotected(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Index recreation details with REINDEX TABLE CONCURRENTLY
Date: 2023-05-10 15:04:43
Message-ID: 87ild0p6d4.fsf@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dhirendra Singh 2023-05-10 15:32:54 Re: Question about pg_wal.tar.gz generated by pg_basebackup
Previous Message Ron 2023-05-10 13:38:22 Re: Question about pg_wal.tar.gz generated by pg_basebackup