On Wed, Nov 16, 2016 at 7:30 PM, dhaval jaiswal <dhavallj(at)hotmail(dot)com>
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.
See: https://www.postgresql.org/docs/9.6/static/catalog-pg-class.html
> 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.