Message-ID: <4698FB0A.4070502@lelarge.info>
Date: Sat, 14 Jul 2007 18:34:18 +0200
From: Guillaume Lelarge <guillaume@lelarge.info>
User-Agent: Thunderbird 1.5.0.12 (X11/20070604)
MIME-Version: 1.0
To: Patric de Waha <lists@p-dw.com>
CC: "Joshua D. Drake" <jd@commandprompt.com>, pgsql-performance@postgresql.org
Subject: Re: Vacuum full considered useful ;)
References: <4698F0CF.7000602@p-dw.com> <4698F8EE.8090603@commandprompt.com>
In-Reply-To: <4698F8EE.8090603@commandprompt.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Joshua D. Drake a écrit :
> 
>>    No wonder, I got IO problems with such a fragmentation.
>>
>>    For people not very familiar with postgres especially those coming 
>> from mysql,
>>    i'd recommend paying attention to this.
> 
> Definitely. The problem here is that you just aren't vacuuming enough, 
> not that you didn't vacuum full. I would suggest reviewing autovacuum 
> and seeing if that will help you.
> 

And paying attention to the max_fsm_pages setting. A value too low won't 
help vacuum's work.

Regards.


-- 
Guillaume.
http://www.postgresqlfr.org
http://docs.postgresqlfr.org