| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | dhaval jaiswal <dhavallj(at)hotmail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_class (system) table increasing size. |
| Date: | 2016-11-17 14:59:46 |
| Message-ID: | 5ec7217c-6bc3-9b40-0ef1-ff99aa6066e9@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Langote | 2016-11-17 15:28:38 | Re: How the Planner in PGStrom differs from PostgreSQL? |
| Previous Message | Adrian Klaver | 2016-11-17 14:45:41 | Re: pg_class (system) table increasing size. |