Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thank you for your response. 

On Fri, Nov 6, 2020 at 11:14 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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 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?

Given that there is no actual useful/hard data in the above the chances
of there being a relevant answer in return is doubtful.

Also given your subsequent post the major version you are using is
nearing 1 year past EOL and is 21 minor releases behind the last release
in the series. At the very least you need to bring it up to the last
minor release.

>
> Did full os restart for the DB server?
>
> Thanks
> Sri.


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux