Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4

Поиск
Список
Период
Сортировка
От Michael Guissine
Тема Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4
Дата
Msg-id CACxDrA=NDMwbAvK3skHeND4xLFV23TZxzBpYiA63h7tJOBHFFw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4  (Jeff Janes <jeff.janes@gmail.com>)
Список 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.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 по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: BUG #17652: Performance degradation after migrating from v13.4 to v14.4
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17653: Bad handling of NUMERIC data type using ODBC driver version 13.2