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