Re: Postgres 12 -> 13 any need to re-index?

From: Thomas Kellerer <shammat(at)gmx(dot)net>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Postgres 12 -> 13 any need to re-index?
Date: 2021-02-09 18:14:09
Message-ID: 3ee9404b-fe47-c215-c373-df7a98b67226@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2021-02-09 18:17:20 Re: Postgres 12 -> 13 any need to re-index?
Previous Message Wells Oliver 2021-02-09 18:13:18 Re: Postgres 12 -> 13 any need to re-index?