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
