Message-ID: <429F2F73.8050406@zeut.net>
Date: Thu, 02 Jun 2005 12:10:27 -0400
From: "Matthew T. O'Connor" <matthew@zeut.net>
Organization: Terrie O'Connor Realtors
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
MIME-Version: 1.0
To: Mindaugas Riauba <mind@bi.lt>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-performance@postgresql.org
Subject: Re: How to avoid database bloat
References: <00d501c5667d$8cc12320$f20214ac@bite.lt>
	<13878.1117636799@sss.pgh.pa.us>
	<018601c56744$9d5aae50$f20214ac@bite.lt>
	<13178.1117719939@sss.pgh.pa.us>
	<02db01c5677e$d43d3b10$f20214ac@bite.lt>
In-Reply-To: <02db01c5677e$d43d3b10$f20214ac@bite.lt>
Content-Type: text/plain; charset=windows-1257; format=flowed
Content-Transfer-Encoding: 7bit

Mindaugas Riauba wrote:

>>AFAICT the vacuum is doing what it is supposed to, and the problem has
>>to be just that it's not being done often enough.  Which suggests either
>>an autovacuum bug or your autovacuum settings aren't aggressive enough.
>>    
>>
>
>  -D -d 1 -v 1000 -V 0.5 -a 1000 -A 0.1 -s 10
>
>  That is autovacuum settings. Should be aggressive enough I think?
>  
>

Might e aggressive enough, but might not.  I have seen some people run 
-V 0.1.  Also you probably don't need -A that low.  This could an issue 
where analyze results in an inaccurate reltuples value which is 
preventing autovacuum from doing it's job.  Could you please run it with 
-d 2 and show us the relevant log output.

>>Which PG version is this exactly?  Some of the earlier autovacuum
>>releases do have known bugs, so it'd be worth your while to update
>>if you're not on the latest point release of your series.
>>    
>>
>
>  8.0.3
>  
>

That should be fine.