Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4 - Mailing list pgsql-bugs

From Michael Guissine
Subject Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4
Date
Msg-id CACxDrA=NDMwbAvK3skHeND4xLFV23TZxzBpYiA63h7tJOBHFFw@mail.gmail.com
Whole thread Raw
In response to Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4
List pgsql-bugs
Tree view
Hi Jeff,

Sorry I should've mentioned that. Yes we did ANALYZE all the tables after upgrade, we even went ahead and REINDEX all indexes and then also run VACUUM ANALYZE but still facing same performance issue

On Wed, Oct 19, 2022 at 1:09 PM Jeff Janes <jeff.janes@gmail.com> wrote:
On Wed, Oct 19, 2022 at 12:21 PM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      17652
Logged by:          Michael Guissine
Email address:      mguissine@gmail.com
PostgreSQL version: 14.4
Operating system:   AWS RDS
Description:       

Hello,

We recently upgraded our AWS RDS instances to PG 14.4 and are seeing weird
performance degradation.

First things first, did you do an ANALYZE on the database after the upgrade?  (Maybe RDS does it for you, I don't know.  But it isn't worth looking into anything else until you make sure that that has been done)

Cheers,

Jeff

pgsql-bugs by date:

Previous
From: Jeff Janes
Date:
Subject: Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4
Next
From: PG Bug reporting form
Date:
Subject: BUG #17653: Bad handling of NUMERIC data type using ODBC driver version 13.2