Postgres Pro
Downloads
Home   >   mailing lists

Reindex after upgrade from PostgreSQL 12.10 to PostgreSQL 15.3 - Mailing list pgsql-general

From Hellen Jiang
Subject Reindex after upgrade from PostgreSQL 12.10 to PostgreSQL 15.3
Date
Msg-id BLAPR17MB4193DBC13856191E1A05CF3ED201A@BLAPR17MB4193.namprd17.prod.outlook.com
Whole thread Raw
Responses Re: Reindex after upgrade from PostgreSQL 12.10 to PostgreSQL 15.3
List pgsql-general
Tree view

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 has partitioned table by month table1_2023_01, table1_2023_02 , table1_2023_03 and so on.

Will that be good if I only run reindex on some partitioned table(table1_2023_06 and table1_2023_07), for example, REINDEX (VERBOSE) TABLE table1_2023_06; REINDEX (VERBOSE) TABLE table1_2023_07;

After reindex part of tables, I will run ANALYZE with vaccumdb

vacuumdb --analyze-only --jobs=8 -d <mydatabase>

 

Will the performance be as good as before I upgrade?

 

 

Thanks,

 

pgsql-general by date:

Previous
From: Ben Hancock
Date:
Subject: Re: Create DB privilege is not inherited
Next
From: Atul Kumar
Date:
Subject: password error in batch script