Re: is pg_autovacuum so effective ?

Gaetano Mendola wrote:

>pg_class after the vacuum full for that table
>
> relfilenode | relname  | relpages |  reltuples
>-------------+----------+----------+-------------
>       18376 | messages |    63307 | 1.60644e+06
>
>
>pg_class before the vacuum full for that table
>
> relfilenode | relname  | relpages |  reltuples
>-------------+----------+----------+-------------
>       18376 | messages |    69472 | 1.60644e+06
>
>
>
>how was possible accumulate 6000 pages wasted on that table?
>
>Between these two calls:
>[2005-02-22 05:25:03 CET] Performing: VACUUM ANALYZE "public"."messages"
>[2005-02-22 15:20:39 CET] Performing: VACUUM ANALYZE "public"."messages"
>
>1768 rows where inserted, and I had 21578 updated for that rows ( each
>row have a counter incremented for each update ) so that table is not
>so heavy updated
>
>I'm running autovacuum with these parameters:
>pg_autovacuum -d 3 -v 300 -V 0.1 -S 0.8 -a 200 -A 0.1 -D
>
>
>shall I run it in a more aggressive way ? May be I'm missing
>something.
>

Well without thinking too much, I would first ask about your FSM
settings?  If they aren't big enought that will cause bloat.  Try
bumping your FSM settings and then see if you reach steady state.