On Fri, Apr 5, 2013 at 7:44 PM, Magnus Hagander <mag...@hagander.net> wrote:
> On Sun, Mar 31, 2013 at 11:44 PM, komunca <komu...@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)? > Could you output the result of this query? SELECT count(*) FROM pg_class; -- Michael
