From: Matthew T. O'Connor <matthew@zeut.net>
To: Mindaugas Riauba <mind@bi.lt>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: How to avoid database bloat
Date: Thu, 02 Jun 2005 12:10:27 -0400
Message-ID: <429F2F73.8050406@zeut.net> (raw)
In-Reply-To: <02db01c5677e$d43d3b10$f20214ac@bite.lt>
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>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: matthew@zeut.net, mind@bi.lt, tgl@sss.pgh.pa.us
Subject: Re: How to avoid database bloat
In-Reply-To: <429F2F73.8050406@zeut.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox