Search Postgresql Archives

Re: pg_class (system) table increasing size.

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

 



On Wed, Nov 16, 2016 at 7:30 PM, dhaval jaiswal <dhavallj@xxxxxxxxxxx> wrote:

PostgreSQL 9.4.0

​Are generalizing here or are you really running ​2+ year old patch version?

Why pg_class table is getting bigger in size. 

​Because you are creating (specific) objects.​

How to stop increasing it. 

​Stop creating (those specific) objects​.

Does it affect the performance.  

​It can - depends greatly on scale.

Note, frequent usage of temporary tables is a common cause for this kind of behavior.

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