Re: After vacuum application runs very slow ? is this common behavior ? - Mailing list pgsql-general

From Sri Linux
Subject Re: After vacuum application runs very slow ? is this common behavior ?
Date
Msg-id CAFcfow-2T3AX_26hFByTx1U2TrXk8Bc70Utw1fH5qyj5v3++gw@mail.gmail.com
Whole thread Raw
In response to After vacuum application runs very slow ? is this common behavior ?  (Sri Linux <srilinux09@gmail.com>)
List pgsql-general
Adding version info

Postgres 9.4.5
Linux - rhel 7.3

Thanks
Sri

On Fri, Nov 6, 2020 at 10:20 PM Sri Linux <srilinux09@gmail.com> wrote:
Hi All,

Our production database size is about 2TB and we had run into issues and Postgres log did recommend running the vacuum in single-user mode. We have successfully completed running a single user mode vacuum without any options. .. services were online after vacuum. Application load time and response times are very poor and don't load sometimes. Is this common behavior after a vacuum? DO we need to consider any post activities or give some time for the database to settle down?

Did full os restart for the DB server?

Thanks 
Sri.

pgsql-general by date:

Previous
From: Sri Linux
Date:
Subject: After vacuum application runs very slow ? is this common behavior ?
Next
From: Adrian Klaver
Date:
Subject: Re: After vacuum application runs very slow ? is this common behavior ?