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