BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: tejaswini(dot)gc(at)decathlon(dot)com
Subject: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good
Date: 2020-04-02 03:52:25
Message-ID: 16334-b99092d62b0bbb9a@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-performance

The following bug has been logged on the website:

Bug reference: 16334
Logged by: Tejaswini GC
Email address: tejaswini(dot)gc(at)decathlon(dot)com
PostgreSQL version: 10.10
Operating system: Centos 7
Description:

Hello Team,

We have upgraded our database into version 10.10.
After upgrading we could see that the system performance is bad , and one of
the applications linked to it via web service is not working.

During this upgrade we have not done any code changes either on the
application side or on our ERP side.

We are trying to debug everything from application perse, but till now we do
not have any lead.

Can you tell us are there any measures that we need to take after upgrade.

What is the ideal setup or paramters that we should have when we upgrade to
v 10.10

Thanks

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kyotaro Horiguchi 2020-04-02 04:04:43 Re: [BUG] non archived WAL removed during production crash recovery
Previous Message Michael Paquier 2020-04-02 02:01:50 Re: BUG #16325: Assert failure on partitioning by int for a text value with a collation

Browse pgsql-performance by date

  From Date Subject
Next Message Julien Rouhaud 2020-04-02 08:46:58 Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good
Previous Message Pavel Stehule 2020-03-30 16:49:22 Re: Increasing work_mem slows down query, why?