From: | Hellen Jiang <hjiang(at)federatedwireless(dot)com> |
---|---|
To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Reindex after upgrade from PostgreSQL 12.10 to PostgreSQL 15.3 |
Date: | 2023-07-27 20:02:29 |
Message-ID: | BLAPR17MB4193DBC13856191E1A05CF3ED201A@BLAPR17MB4193.namprd17.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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,
From | Date | Subject | |
---|---|---|---|
Next Message | Atul Kumar | 2023-07-27 20:17:30 | password error in batch script |
Previous Message | Ben Hancock | 2023-07-27 14:37:17 | Re: Create DB privilege is not inherited |