Обсуждение: Index - Concurrently Method
Hello Guys,
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.
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;
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!
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 createthe 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. Soit'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
Thanks, I'll check it out.
Laurenz Albe <laurenz.albe@cybertec.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