Enquiry about Percona TDE performance issues

From: Ashish Mukherjee <ashish(dot)mukherjee(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Enquiry about Percona TDE performance issues
Date: 2025-09-25 11:36:33
Message-ID: CACgMzfxGyCQHhE3BOrn0c8GpAd0ZMQGc80_C-qYUWZArEKqbZg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Roberto Gallesio 2025-09-25 15:38:42 Compatibility Informations
Previous Message Ron Johnson 2025-09-24 23:34:03 Re: Index rebuilding strategy