wstrzalka <[EMAIL PROTECTED]> 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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
