Re: How to avoid database bloat

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.