[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Reindex after upgrade from PostgreSQL 12.10 to PostgreSQL 15.3
From:       Laurenz Albe <laurenz.albe () cybertec ! at>
Date:       2023-07-28 10:48:37
Message-ID: b9fa428d6a8b33bc1e754c0802f250394b207815.camel () cybertec ! at
[Download RAW message or body]

On Thu, 2023-07-27 at 20:02 +0000, Hellen Jiang wrote:
> I am going to upgrade our production database( postgresql 12.10) to postg=
resql 15.3.
> After upgrade to 15.3, =C2=A0Do 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


[prev in list] [next in list] [prev in thread] [next in thread]