Re: Index - Concurrently Method

Thanks, I'll check it out.

Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, 12 Haz 2024 Çar, 09:39 tarihinde
şunu yazdı:

> On Wed, 2024-06-12 at 00:15 +0300, SOzcn wrote:
> > 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;
>
> No, there is no other way. But the commands you quote seem to be the wrong
> way around. It should be:
>
> CREATE INDEX idx_sales_order_date ON ONLY sales (order_date);
>
> 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_order_date ATTACH PARTITION
> idx_sales_2020_order_date;
> ALTER INDEX idx_sales_order_date ATTACH PARTITION
> idx_sales_2021_order_date;
> ALTER INDEX idx_sales_order_date ATTACH PARTITION
> idx_sales_2022_order_date;
>
> Yours,
> Laurenz Albe
>