Postgres Pro
Downloads
Home   >   mailing lists

Re: High CPU usage of stats collector - Mailing list pgsql-general

From Magnus Hagander
Subject Re: High CPU usage of stats collector
Date
Msg-id CABUevEwDJ2k3Fn_Av5HqjDbR5skzgmD2_=JGEve1WND=9dfb9A@mail.gmail.com
Whole thread Raw
In response to High CPU usage of stats collector  (komunca <komunca@gmail.com>)
Responses Re: High CPU usage of stats collector
Re: High CPU usage of stats collector
List pgsql-general
Tree view 
On Sun, Mar 31, 2013 at 11:44 PM, komunca <komunca@gmail.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?

Do you by any chance have a large number of databases, and/or a large
number of objects in your databases (tables or indexes)?

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

pgsql-general by date:

Previous
From: Condor
Date:
Subject: Re: Need advice to avoid ORDER BY
Next
From: Dmitriy Igrishin
Date:
Subject: Bug or feature? (The constraint of the domain of extension can be dropped...)