wstrzalka <wstrzalka@gmail.com> writes:
> the 15483 process is stats collector. At the moment server is almost
> idle but the stats collector is constantly taking 15-17% of CPU.
> I don't know if it matters at all, but maybe the reason is that the
> cluster is very large in the term of relation number (many schemes
> with identical table set).
> select count(*) from pg_class;
> count
> --------
> 257477
Ouch. You might want to consider a schema redesign. Usually, if you've
got a lot of tables with the same column-set, it's better to combine
them into one big table with an additional key column.
I'm sure the stats collector runtime is directly tied to having so many
tables --- it's trying to keep stats on each one of them individually.
regards, tom lane