From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Sri Linux <srilinux09(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: After vacuum application runs very slow ? is this common behavior ? |
Date: | 2020-11-07 05:14:32 |
Message-ID: | bf228514-339a-ade6-3137-9309f82a3da9@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2020-11-07 08:20:50 | Re: Reference-Partitioned Tables |
Previous Message | Sri Linux | 2020-11-07 04:51:39 | Re: After vacuum application runs very slow ? is this common behavior ? |