The upgrade was done by taking a complete dump of the schema + data from v12 instance and then restoring to v17. Used pg_dump and pg_restore respectively.
Yes, Vacuum analyze was also run on the new instance.
On 9/25/25 04:36, Ashish Mukherjee wrote: > Hello, > > I recently upgraded from pgsql 12 to pgsql 17. It's a Percona TDE > enabled database. However, after the upgrade the query planning time has > shot up by 10x when I check explain analyze output.
Did the Postgres 12 instance have the Percona TDE extension installed also?
How did you do the upgrade?
Did you run ANALYZE on the new Postgres 17 instance?
