2009/5/25 Łukasz Jagiełło <lukasz.jagiello@xxxxxxxxxx>: > W dniu 25 maja 2009 17:32 użytkownik Scott Marlowe > <scott.marlowe@xxxxxxxxx> napisał: >>> 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? > > Guess you was right > For future reference, if you don't log postgresql's messages, please turn at least basic logging on, and things like that you would find in $PGDATA/pg_log/ logs. The value suggested by postgresql, is the minimum. I usually put in 1.5 the suggestion, which covers me from worse case hopefully. -- GJ -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
