Re: pg_class (system) table increasing size.

Поиск
Список
Период
Сортировка
От dhaval jaiswal
Тема Re: pg_class (system) table increasing size.
Дата
Msg-id PN1PR01MB0046F37B2DFE0D0E11D5F34FDFB10@PN1PR01MB0046.INDPRD01.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответ на Re: pg_class (system) table increasing size.  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: pg_class (system) table increasing size.  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: pg_class (system) table increasing size.  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Дерево обсуждения


>> 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 the pg_class.


It seems its affecting performance.

From: David G. Johnston <david.g.johnston@gmail.com>
Sent: Thursday, November 17, 2016 8:13 AM
To: dhaval jaiswal
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_class (system) table increasing size.
 
On Wed, Nov 16, 2016 at 7:30 PM, dhaval jaiswal <dhavallj@hotmail.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.
 

В списке pgsql-general по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Request to share information regarding deadlock in postgresql-9.3.6
Следующее
От: Venkata B Nagothi
Дата:
Сообщение: Re: Check integrity between servers