2009/5/24 Łukasz Jagiełło <lukasz(dot)jagiello(at)gforces(dot)pl>:
> 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
> 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
Whats the last 20 or so lines of vacuum verbose as run by a superuser say?
In response to
pgsql-performance by date
|Next:||From: Grzegorz Jaśkiewicz||Date: 2009-05-25 15:50:35|
|Subject: Re: Problems with autovacuum|
|Previous:||From: David Blewett||Date: 2009-05-25 15:22:38|
|Subject: Re: Bad Plan for Questionnaire-Type Query|