From: | dhaval jaiswal <dhavallj(at)hotmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(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 18:33:47 |
Message-ID: | PN1PR01MB0046605D86BDE568A060FB99DFB10@PN1PR01MB0046.INDPRD01.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
select * from pg_stat_sys_tables where relname = 'pg_class';
-[ RECORD 1 ]-------+-----------
relid | 1259
schemaname | pg_catalog
relname | pg_class
seq_scan | 1838
seq_tup_read | 3177416
idx_scan | 1027456557
idx_tup_fetch | 959682909
n_tup_ins | 0
n_tup_upd | 0
n_tup_del | 0
n_tup_hot_upd | 0
n_live_tup | 0
n_dead_tup | 0
n_mod_since_analyze | 0
last_vacuum |
last_autovacuum |
last_analyze |
last_autoanalyze |
vacuum_count | 0
autovacuum_count | 0
analyze_count | 0
autoanalyze_count | 0
Yes, the size of pg_class table is of 5 GB. However, the existing row is only 2380 only. It's got fragmented.
________________________________
From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Sent: Thursday, November 17, 2016 8:29 PM
To: dhaval jaiswal; David G. Johnston
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] pg_class (system) table increasing size.
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 | rob stone | 2016-11-17 18:47:51 | Re: help with moving tablespace |
Previous Message | kbrannen | 2016-11-17 18:19:33 | Re: help with moving tablespace |