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

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: Postgres 12 -> 13 any need to re-index?
Дата
Msg-id 3ee9404b-fe47-c215-c373-df7a98b67226@gmx.net
обсуждение исходный текст
Ответ на Postgres 12 -> 13 any need to re-index?  (Wells Oliver <wells.oliver@gmail.com>)
Список 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.




В списке pgsql-admin по дате отправления:

Предыдущее
От: Wells Oliver
Дата:
Сообщение: Re: Postgres 12 -> 13 any need to re-index?
Следующее
От: Ron
Дата:
Сообщение: Re: Postgres 12 -> 13 any need to re-index?