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.
It is not any one object, it is the total of the objects(relations) as
defined here:
https://www.postgresql.org/docs/9.4/static/catalog-pg-class.html
48.11. pg_class
relkind char r = ordinary table, i = index, S = sequence, v = view,
m = materialized view, c = composite type, t = TOAST table, f = foreign
table
So if you do something like:
select relkind, relname from pg_class order by relkind, relname;
you should see what the entries are the table by their type. Might give
you a clue as to what is causing the growth.
We do not have the much temporary table usage.
Since the size is bigger (5 GB) to maintain. does it requires
The size you are referring to is the database size, the table size or
something else?
maintenance as well for thepg_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.
On Wed, Nov 16, 2016 at 7:30 PM, dhaval jaiswal <dhavallj@xxxxxxxxxxx
<mailto:dhavallj@xxxxxxxxxxx>>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.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
