Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_class (system) table increasing size. - Mailing list pgsql-general

From Igor Neyman
Subject Re: pg_class (system) table increasing size.
Date
Msg-id MWHPR07MB287703505A1AA19FD942EC9FDAB50@MWHPR07MB2877.namprd07.prod.outlook.com
Whole thread Raw
In response to Re: pg_class (system) table increasing size.  (dhaval jaiswal <dhavallj@hotmail.com>)
List pgsql-general
Tree view

 

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of dhaval jaiswal
Sent: Monday, November 21, 2016 12:35 PM
To: Kevin Grittner <kgrittn@gmail.com>; Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>; David G. Johnston <david.g.johnston@gmail.com>; pgsql-general@postgresql.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

 

You just stated the reason:

“auto vacuum is off”

 

Regards,

Igor Neyman

pgsql-general by date:

Previous
From: dhaval jaiswal
Date:
Subject: Re: pg_class (system) table increasing size.
Next
From: Alvaro Herrera
Date:
Subject: Re: pg_class (system) table increasing size.