Re: [GENERAL] High CPU usage of stats collector

2013-04-06 Thread Jeff Janes
On Sun, Mar 31, 2013 at 2:44 PM, komunca 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

Re: [GENERAL] High CPU usage of stats collector

2013-04-05 Thread komunca
yes. maybe ~200 databases -- View this message in context: http://postgresql.1045698.n5.nabble.com/High-CPU-usage-of-stats-collector-tp5750271p5750918.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.

Re: [GENERAL] High CPU usage of stats collector

2013-04-05 Thread komunca
*288* -- View this message in context: http://postgresql.1045698.n5.nabble.com/High-CPU-usage-of-stats-collector-tp5750271p5750925.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] High CPU usage of stats collector

2013-04-05 Thread Michael Paquier
On Fri, Apr 5, 2013 at 7:44 PM, Magnus Hagander wrote: > On Sun, Mar 31, 2013 at 11:44 PM, komunca 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

Re: [GENERAL] High CPU usage of stats collector

2013-04-05 Thread Magnus Hagander
On Sun, Mar 31, 2013 at 11:44 PM, komunca 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

[GENERAL] High CPU usage of stats collector

2013-04-05 Thread komunca
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? Thanks -- View this message in context: http://postgresql.1045698.n5.nabble.com/High-CPU-