Re: Reindex after upgrade from PostgreSQL 12.10 to PostgreSQL 15.3

2023-07-28 Thread Laurenz Albe
On Thu, 2023-07-27 at 20:02 +, Hellen Jiang wrote: > I am going to upgrade our production database( postgresql 12.10) to > postgresql 15.3. > After upgrade to 15.3,  Do you have to do re-index? That is not necessary after a PostgreSQL upgrade. (It may be necessary if you upgrade the operatin

Reindex after upgrade from PostgreSQL 12.10 to PostgreSQL 15.3

2023-07-28 Thread Hellen Jiang
Hi, I am going to upgrade our production database( postgresql 12.10) to postgresql 15.3. After upgrade to 15.3, Do you have to do re-index? If I have to do re-index, can I only do re-index on some partitioned tables? We have a lot of big tables which are partitioned by date, for example, table1