Yes, PgSQL 12 also had TDE 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 Fri, Sep 26, 2025 at 12:40 AM Adrian Klaver <[email protected]> wrote: > 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? > > > > > > Regards, > > Ashish > > > -- > Adrian Klaver > [email protected] >
