From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of dhaval jaiswal Sent: Monday, November 21, 2016 12:35 PM To: Kevin Grittner <kgri...@gmail.com>; Alvaro Herrera <alvhe...@2ndquadrant.com> Cc: Adrian Klaver <adrian.kla...@aklaver.com>; David G. Johnston <david.g.johns...@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<http://aka.ms/weboutlook> ________________________________ You just stated the reason: "auto vacuum is off" Regards, Igor Neyman