Search Postgresql Archives

Re: pg_class (system) table increasing size.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Nov 21, 2016 at 10:34 AM, dhaval jaiswal <dhavallj@xxxxxxxxxxx> 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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux