Home > mailing lists

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

From	David G. Johnston
Subject	Re: pg_class (system) table increasing size.
Date	November 21, 2016 20:45:36
Msg-id	CAKFQuwZ5nLLrHxxnTT_r7-q9_6Fy6drgwom3o6He+ZUUWB0a4Q@mail.gmail.com Whole thread Raw
In response to	Re: pg_class (system) table increasing size. (dhaval jaiswal <dhavallj@hotmail.com>)
List	pgsql-general

On Mon, Nov 21, 2016 at 10:34 AM, dhaval jaiswal <dhavallj@hotmail.com> wrote:

Due to business impact auto vacuum is off.

You won't get much sympathy if you turn this feature off. The question you should be pondering is how to properly configure it for your environment.

pg_class gets bloated for the same reasons other tables do - updates and deletes to rows (which here represent system objects).

David J.

From: Alvaro Herrera
Date: 21 November 2016, 20:45:32
Subject: Re: pg_class (system) table increasing size.

From: dhaval jaiswal
Date: 21 November 2016, 20:45:42
Subject: Re: pg_class (system) table increasing size.