Re: Reindex after upgrade from PostgreSQL 12.10 to PostgreSQL 15.3

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Hellen Jiang <hjiang(at)federatedwireless(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Reindex after upgrade from PostgreSQL 12.10 to PostgreSQL 15.3
Date: 2023-07-28 10:48:37
Message-ID: b9fa428d6a8b33bc1e754c0802f250394b207815.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2023-07-27 at 20:02 +0000, Hellen Jiang wrote:
> 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?

That is not necessary after a PostgreSQL upgrade.

(It may be necessary if you upgrade the operating system.)

> Will the performance be as good as before I upgrade?

It should be at least as good, but sometimes it isn't.
That's why you test (and tune if necessary).

Yours,
Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message gzh 2023-07-28 11:50:29 Re: How to improve the performance of my SQL query？
Previous Message Daniel Westermann (DWE) 2023-07-28 10:36:46 Understanding pg_stat_io.evictions