Re: pg_class (system) table increasing size.
| От | Igor Neyman |
|---|---|
| Тема | Re: pg_class (system) table increasing size. |
| Дата | |
| Msg-id | MWHPR07MB287703505A1AA19FD942EC9FDAB50@MWHPR07MB2877.namprd07.prod.outlook.com обсуждение исходный текст |
| Ответ на | Re: pg_class (system) table increasing size. (dhaval jaiswal <dhavallj@hotmail.com>) |
| Список | pgsql-general |
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of dhaval jaiswal
Sent: Monday, November 21, 2016 12:35 PM
To: Kevin Grittner <kgrittn@gmail.com>; Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>; David G. Johnston <david.g.johnston@gmail.com>; pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_class (system) table increasing size.
I did check and found it was the bloated size of pg_class which was slowing down the performance.
It got fixed by adding in routine maintenance task. Things are fine now.
However, I want to know how come pg_class (system table) get bloated/affected.
What could be the possible ways, where i can look into.
Due to business impact auto vacuum is off.
Sent from Outlook
You just stated the reason:
“auto vacuum is off”
Regards,
Igor Neyman
В списке pgsql-general по дате отправления: