public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ashish Mukherjee <[email protected]>
To: [email protected]
Subject: Enquiry about Percona TDE performance issues
Date: Thu, 25 Sep 2025 17:06:33 +0530
Message-ID: <CACgMzfxGyCQHhE3BOrn0c8GpAd0ZMQGc80_C-qYUWZArEKqbZg@mail.gmail.com> (raw)
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
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: Enquiry about Percona TDE performance issues
In-Reply-To: <CACgMzfxGyCQHhE3BOrn0c8GpAd0ZMQGc80_C-qYUWZArEKqbZg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox