| From: | Sri Linux <srilinux09(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: After vacuum application runs very slow ? is this common behavior ? |
| Date: | 2020-11-07 04:51:39 |
| Message-ID: | CAFcfow-2T3AX_26hFByTx1U2TrXk8Bc70Utw1fH5qyj5v3++gw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gmail(dot)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.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2020-11-07 05:14:32 | Re: After vacuum application runs very slow ? is this common behavior ? |
| Previous Message | Sri Linux | 2020-11-07 04:20:17 | After vacuum application runs very slow ? is this common behavior ? |