Re: Enquiry about Percona TDE performance issues
| От | Ashish Mukherjee |
|---|---|
| Тема | Re: Enquiry about Percona TDE performance issues |
| Дата | |
| Msg-id | CACgMzfzPEkWpGx3GpFQzZw2p-FdowsDVeGkC9A5KpOKcWsa93w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Enquiry about Percona TDE performance issues (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Список | pgsql-general |
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 <adrian.klaver@aklaver.com> 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
adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления: