Re: High CPU usage of stats collector

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: komunca <komunca(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: High CPU usage of stats collector
Date: 2013-04-06 18:46:26
Message-ID: CAMkU=1y_NP2C_bMJ+O6EHHB69ecG2qBgksOLVYiP=-A91fRy9Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Mar 31, 2013 at 2:44 PM, komunca <komunca(at)gmail(dot)com> wrote:

> On my db server I have noticed a very high CPU usage of process:
> *postgres: stats collector process*
>
> It is not below 50% of CPU. (Info from htop).
>
> What is best way to decrease CPU usage of this process?
>

This is a known issue when you have a large number of databases with a
large number of objects each.

It will be fixed in 9.3. In the meantime you can perhaps increase
autovacuum_naptime, but that has tradeoffs.

Cheers,

Jeff

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jared Beck 2013-04-06 21:16:16 REL/Centos4 release of 8.4.17?
Previous Message Tom Lane 2013-04-06 16:03:54 Re: Source code and database object identifiers