Re: pg_class (system) table increasing size.

[Igor Neyman <ineyman@xxxxxxxxxxxxxx>]

 

From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of dhaval jaiswal
Sent: Monday, November 21, 2016 12:35 PM
To: Kevin Grittner <kgrittn@xxxxxxxxx>; Alvaro Herrera <alvherre@xxxxxxxxxxxxxxx>
Cc: Adrian Klaver <adrian.klaver@xxxxxxxxxxx>; David G. Johnston <david.g.johnston@xxxxxxxxx>; pgsql-general@xxxxxxxxxxxxxx
Subject: Re: 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