| From: | Igor Neyman <ineyman(at)perceptron(dot)com> |
|---|---|
| To: | dhaval jaiswal <dhavallj(at)hotmail(dot)com>, Kevin Grittner <kgrittn(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_class (system) table increasing size. |
| Date: | 2016-11-21 17:47:39 |
| Message-ID: | MWHPR07MB287703505A1AA19FD942EC9FDAB50@MWHPR07MB2877.namprd07.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of dhaval jaiswal
Sent: Monday, November 21, 2016 12:35 PM
To: Kevin Grittner <kgrittn(at)gmail(dot)com>; Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>; David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] pg_class (system) table increasing size.
I did check and found it was the bloated size of pg_class which was slowing down the performance.
It got fixed by adding in routine maintenance task. Things are fine now.
However, I want to know how come pg_class (system table) get bloated/affected.
What could be the possible ways, where i can look into.
Due to business impact auto vacuum is off.
Sent from Outlook<http://aka.ms/weboutlook>
________________________________
You just stated the reason:
"auto vacuum is off"
Regards,
Igor Neyman
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2016-11-21 17:49:21 | Re: pg_class (system) table increasing size. |
| Previous Message | dhaval jaiswal | 2016-11-21 17:45:29 | Re: pg_class (system) table increasing size. |