| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | dhaval jaiswal <dhavallj(at)hotmail(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 02:43:31 |
| Message-ID: | CAKFQuwb7kA_hUE47_uuRe90mBRKDKM6RmuAzJc+VVz583sbhGg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2016-11-17 03:04:08 | Re: Request to share information regarding deadlock in postgresql-9.3.6 |
| Previous Message | dhaval jaiswal | 2016-11-17 02:30:02 | pg_class (system) table increasing size. |