| From: | Michael Guissine <mguissine(at)gmail(dot)com> |
|---|---|
| To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4 |
| Date: | 2022-10-19 17:30:16 |
| Message-ID: | CACxDrA=NDMwbAvK3skHeND4xLFV23TZxzBpYiA63h7tJOBHFFw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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(dot)janes(at)gmail(dot)com> wrote:
> On Wed, Oct 19, 2022 at 12:21 PM PG Bug reporting form <
> noreply(at)postgresql(dot)org> wrote:
>
>> The following bug has been logged on the website:
>>
>> Bug reference: 17652
>> Logged by: Michael Guissine
>> Email address: mguissine(at)gmail(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Bug reporting form | 2022-10-19 18:18:45 | BUG #17653: Bad handling of NUMERIC data type using ODBC driver version 13.2 |
| Previous Message | Jeff Janes | 2022-10-19 17:09:11 | Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4 |