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.kennedy.486@gmail.com> w dniu 28.08.2023, o godz. 15:51:
How to safely perform a reindex partitioned tables (postgresql 12)
Regards,