Обсуждение: Enquiry about Percona TDE performance issues

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. 

The difference in planning time is visible here. The first case is pgsql 17 with TDE. The second case pgsql 12 with TDE.

s14=> explain analyze select invoicenum from ltlinvoice where pseq=1400000224216382;
                                                          QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
 Index Scan using ltlinvoice_pseq on ltlinvoice  (cost=0.43..10.10 rows=9 width=12) (actual time=0.040..0.040 rows=0 loops=1)
   Index Cond: (pseq = '1400000224216382'::bigint)
 Planning Time: 158.199 ms
 Execution Time: 0.051 ms

s14=> explain analyze select invoicenum from ltlinvoice where pseq=1400000224216382;
                                                          QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
 Index Scan using ltlinvoice_pseq on ltlinvoice  (cost=0.43..10.10 rows=9 width=12) (actual time=0.023..0.023 rows=0 loops=1)
   Index Cond: (pseq = '1400000224216382'::bigint)
 Planning Time: 0.195 ms
 Execution Time: 0.046 ms

Any pointers about this would be helpful.

Regards,

Ashish

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.