On 11/16/2016 07:08 PM, dhaval jaiswal wrote:
>
>>> 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 thepg_class.
Should have added to my previous post. What does:
select * from pg_stat_sys_tables where relname = 'pg_class';
show?
>
>
> It seems its affecting performance.
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com