Index - Concurrently Method

From: SOzcn <selahattinozcnma(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Index - Concurrently Method
Date: 2024-06-11 21:15:17
Message-ID: CAJyV5Abye51ReNuQCcBXpGPYs=VXw6XzQfBHe1HBWafdi66=Fw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello Guys,

I hope everything is well with you all.

Is there any other way to use the concurrent method on the table which has
partitioning?

I found something, first of all, it's advised to create the indexes
concurrently on your partitioning tables and then create the index on your
main after this progress attach the indexes.

Does anybody have any experience with this issue?

I leave the example in the belong. Is that way healthy? At the last time,
we gonna create on the main table anyway. So it's kinda confusing me.

By Example;
CREATE INDEX CONCURRENTLY idx_sales_2020_order_date ON sales_2020
(order_date);
CREATE INDEX CONCURRENTLY idx_sales_2021_order_date ON sales_2021
(order_date);
CREATE INDEX CONCURRENTLY idx_sales_2022_order_date ON sales_2022
(order_date);

ALTER INDEX idx_sales_2020_order_date ATTACH PARTITION idx_sales_order_date;
ALTER INDEX idx_sales_2021_order_date ATTACH PARTITION idx_sales_order_date;
ALTER INDEX idx_sales_2022_order_date ATTACH PARTITION idx_sales_order_date;

Have a nice day!

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2024-06-12 06:38:59 Re: Index - Concurrently Method
Previous Message Charles Schultz 2024-06-11 11:22:35 Re: Questions on recovery situations (not urgent)