Hello Julien,
Thanks for your response.
I'm in touch with our hosting team to get more information for your queries.
As of now I can share these details.
We did analyze on the DB, but not the vacuum,
We are using AWS RDS.
Please help me with these queries as well.
1) Will the process change if we use AWS RDS.
2) What kind of vacuum should be done on the DB, as there are many types of vacuum.
Awaiting your reply!
Thanks!
Regards
Tejaswini G C
IT Retail Team
On Thu, Apr 2, 2020 at 2:17 PM Julien Rouhaud <rjuju123@xxxxxxxxx> wrote:
Hi,
On Thu, Apr 02, 2020 at 03:52:25AM +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference: 16334
> Logged by: Tejaswini GC
> Email address: tejaswini.gc@xxxxxxxxxxxxx
> PostgreSQL version: 10.10
> Operating system: Centos 7
> Description:
First of all, this is not a bug. You should have instead started a discussion
on pgsql-general or pgsql-performance. I'm redirecting the discussion on
-performance.
> We have upgraded our database into version 10.10.
How did you upgrade?
> 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.
Do you have any errors in the postgres logs?
> 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.
It depends on how you did the upgrade. If you used pg_upgrade, did you run the
generated script as documented in step 13 at
https://www.postgresql.org/docs/current/pgupgrade.html?
Otherwise, at least a database-wide VACUUM ANALYZE on every database is the
bare minimum to run after an upgrade.
