Re: Reindex after upgrade from PostgreSQL 12.10 to PostgreSQL 15.3

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