2009/5/24 Łukasz Jagiełło <lukasz.jagie...@gforces.pl>:
> Hi,
>
> Recent change postgresql server from Amazon EC2 small into large one.
> That gives me x86_64 arch, two core cpu and 7.5GB ram. Atm got almost
> ~2000 small databases at that server and autovacuum working hole time

> postgresql.conf:
> max_fsm_pages = 204800
> max_fsm_relations = 4000

So, in 2000 databases, there's only an average of 2 relations per db
and 102 dead rows?  Cause that's all you got room for with those
settings.

Whats the last 20 or so lines of vacuum verbose as run by a superuser say?

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to