Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres 12 -> 13 any need to re-index? - Mailing list pgsql-admin

From Thomas Kellerer
Subject Re: Postgres 12 -> 13 any need to re-index?
Date
Msg-id 3ee9404b-fe47-c215-c373-df7a98b67226@gmx.net
Whole thread Raw
In response to Postgres 12 -> 13 any need to re-index?  (Wells Oliver <wells.oliver@gmail.com>)
List pgsql-admin
Tree view 
Wells Oliver schrieb am 09.02.2021 um 19:00:
> Hey guys, I just upgraded a DB from 12 to 13. In testing this seemed
> to go well, but it seems like most of my queries are not using the
> indexes after the upgrade, so everything is quite so.
>
> Is there a general need to REINDEX after upgrading to 13, or might
> there be another issue? The configuration parameters are the same as
> they were persisted via pg_upgradecluster.


If you want to profit from the new de-duplication in indexes, you will need to reindex.

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Re: Postgres 12 -> 13 any need to re-index?
Next
From: Ron
Date:
Subject: Re: Postgres 12 -> 13 any need to re-index?