>> Because you are creating (specific) objects. I have gone through the link and how would i figure out which specific object is causing this. Can you please elaborate more here.
We do not have the much temporary table usage.
Since the size is bigger (5 GB) to maintain. does it requires maintenance as well for the pg_class.
It seems its affecting performance. From: David G. Johnston <david.g.johnston@xxxxxxxxx>
Sent: Thursday, November 17, 2016 8:13 AM To: dhaval jaiswal Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: pg_class (system) table increasing size.
Are generalizing here or are you really running 2+ year old patch version?
Because you are creating (specific) objects.
Stop creating (those specific) objects.
It can - depends greatly on scale.
Note, frequent usage of temporary tables is a common cause for this kind of behavior.
David J.
|