Upgrade PG from 12 to latest

2024-06-23 Thread Doron Tsur
Hello Folks, We are running PG 12 on AWS RDS. I want to run an upgrade process for the DB. The org I work for attempted to upgrade before but failed (12->15). The upgrade resulted in unexplained slowness, and performance issues were only resolved via a downgrade. Do you have any upgrade docs or re

Re: The performance issues caused by upgrading PostgreSQL to version 16.3.

2025-02-17 Thread Doron Tsur
post installing, did you run analyze verbose? -Doron On Mon, Feb 17, 2025 at 4:23 PM Greg Sabino Mullane wrote: > On Mon, Feb 17, 2025 at 2:55 AM 馬 騰飛 wrote: > >> Interestingly, when we isolate the problematic SQL statement and replace >> its parameters with actual values, it executes in just