Re: Problems with autovacuum
От | Scott Marlowe |
---|---|
Тема | Re: Problems with autovacuum |
Дата | |
Msg-id | dcc563d10905250832s2b937943r685c6449d3c8253b@mail.gmail.com обсуждение исходный текст |
Ответ на | Problems with autovacuum (Łukasz Jagiełło <lukasz.jagiello@gforces.pl>) |
Ответы |
Re: Problems with autovacuum
Re: Problems with autovacuum |
Список | pgsql-performance |
2009/5/24 Łukasz Jagiełło <lukasz.jagiello@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?
В списке pgsql-performance по дате отправления: