Re: High CPU usage of stats collector

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: komunca <komunca(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: High CPU usage of stats collector
Date: 2013-04-05 10:44:55
Message-ID: CABUevEwDJ2k3Fn_Av5HqjDbR5skzgmD2_=JGEve1WND=9dfb9A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Mar 31, 2013 at 11: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?

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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message komunca 2013-04-05 11:21:50 Re: High CPU usage of stats collector
Previous Message Condor 2013-04-05 09:54:14 Re: Need advice to avoid ORDER BY