Re: High CPU usage of stats collector

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: High CPU usage of stats collector
Дата
Msg-id CAB7nPqSBAO5AQd39qPNdKBhffdVmdUo_+HebkB-SpD5XcvnkYw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: High CPU usage of stats collector  (Magnus Hagander <magnus@hagander.net>)
Ответы Re: High CPU usage of stats collector
Список pgsql-general
Дерево обсуждения



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

В списке pgsql-general по дате отправления:

Предыдущее
От: Dmitriy Igrishin
Дата:
Сообщение: Bug or feature? (The constraint of the domain of extension can be dropped...)
Следующее
От: Zahid Quadri
Дата:
Сообщение: how to completely disable toasted table in postgresql and best practices to follow