PostgreSQL 12 reindex

Started by Joseph Kennedyover 2 years ago2 messagesgeneral
Jump to latest
#1Joseph Kennedy
joseph.kennedy.486@gmail.com

How to safely perform a reindex partitioned tables (postgresql 12)

Regards,
Jk

#2Joseph Kennedy
joseph.kennedy.486@gmail.com
In reply to: Joseph Kennedy (#1)
Re: PostgreSQL 12 reindex

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

Show quoted text

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,
Jk