It’s good idea do that like this:
REINDEX TABLE CONCURRENTLY partitioned_table_1
REINDEX TABLE CONCURRENTLY partitioned_tab_2
REINDEX TABLE CONCURRENTLY partitioned_table_3
Regards,
JK
> Wiadomość napisana przez Joseph Kennedy <joseph(dot)kennedy(dot)486(at)gmail(dot)com> w dniu 28.08.2023, o godz. 15:51:
>
> How to safely perform a reindex partitioned tables (postgresql 12)
>
> Regards,
> Jk
>
>