Re: Problems with autovacuum - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Problems with autovacuum
Date
Msg-id dcc563d10905250832s2b937943r685c6449d3c8253b@mail.gmail.com
Whole thread Raw
In response to Problems with autovacuum  (Łukasz Jagiełło <lukasz.jagiello@gforces.pl>)
Responses Re: Problems with autovacuum
Re: Problems with autovacuum
List 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 by date:

Previous
From: David Blewett
Date:
Subject: Re: Bad Plan for Questionnaire-Type Query
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: Problems with autovacuum