public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ashish Mukherjee <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: [email protected]
Subject: Re: Enquiry about Percona TDE performance issues
Date: Fri, 26 Sep 2025 09:27:09 +0530
Message-ID: <CACgMzfzPEkWpGx3GpFQzZw2p-FdowsDVeGkC9A5KpOKcWsa93w@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CACgMzfxGyCQHhE3BOrn0c8GpAd0ZMQGc80_C-qYUWZArEKqbZg@mail.gmail.com>
<[email protected]>
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]
>
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], [email protected]
Subject: Re: Enquiry about Percona TDE performance issues
In-Reply-To: <CACgMzfzPEkWpGx3GpFQzZw2p-FdowsDVeGkC9A5KpOKcWsa93w@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