Re: After vacuum application runs very slow ? is this common behavior ?

Thank you for your response. On Fri, Nov 6, 2020 at 11:14 PM Adrian Klaver wrote: > On 11/6/20 8:20 PM, Sri Linux 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

Re: After vacuum application runs very slow ? is this common behavior ?

On 11/6/20 8:20 PM, Sri Linux 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 onlin

Re: After vacuum application runs very slow ? is this common behavior ?

Adding version info Postgres 9.4.5 Linux - rhel 7.3 Thanks Sri On Fri, Nov 6, 2020 at 10:20 PM Sri Linux 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 com

After vacuum application runs very slow ? is this common behavior ?

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