| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | dhaval jaiswal <dhavallj(at)hotmail(dot)com> |
| Cc: | Kevin Grittner <kgrittn(at)gmail(dot)com>, 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:44:58 |
| Message-ID: | 20161121174458.icjbavkctm423fp5@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
dhaval jaiswal wrote:
> 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.
Good to know.
> 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.
The most common cause is high traffic temp table usage.
> Due to business impact auto vacuum is off.
Yeah, that's a really bad idea and you should turn it on and configure
it so that it doesn't impact business. Having it turned off is
definitely not recommended.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2016-11-21 17:45:28 | Re: pg_class (system) table increasing size. |
| Previous Message | dhaval jaiswal | 2016-11-21 17:34:56 | Re: pg_class (system) table increasing size. |