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
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 |