Performance issues after pg_upgrade from pg 11 to pg 12.5

From: Mai Peng <maily(dot)peng(at)webedia-group(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Performance issues after pg_upgrade from pg 11 to pg 12.5
Date: 2020-12-21 08:07:34
Message-ID: 80E12FE1-4C2A-4617-8EF5-E931D47459FD@webedia-group.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

After the pg_upgrade, and analyze_new_cluster, I’ve got serious performance issues. Some queries ( big insert) take more than 3 or 4 times to execute.
Thanks for your help.

Browse pgsql-admin by date

  From Date Subject
Next Message Yambu 2020-12-21 09:48:42 Logical replication stops updating
Previous Message Laurenz Albe 2020-12-21 03:50:02 Re: Replication failed