Skip site navigation (1) Skip section navigation (2)

Re: Problems with autovacuum

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Łukasz Jagiełło <lukasz(dot)jagiello(at)gforces(dot)pl>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Problems with autovacuum
Date: 2009-05-25 15:32:20
Message-ID: dcc563d10905250832s2b937943r685c6449d3c8253b@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
2009/5/24 Łukasz Jagiełło <lukasz(dot)jagiello(at)gforces(dot)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?

In response to

Responses

pgsql-performance by date

Next:From: Grzegorz JaśkiewiczDate: 2009-05-25 15:50:35
Subject: Re: Problems with autovacuum
Previous:From: David BlewettDate: 2009-05-25 15:22:38
Subject: Re: Bad Plan for Questionnaire-Type Query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group