Re: vacuuming problems continued - Mailing list pgsql-performance

From Tom Lane
Subject Re: vacuuming problems continued
Date
Msg-id 12384.1149174355@sss.pgh.pa.us
Whole thread Raw
In response to vacuuming problems continued  (Antoine <melser.anton@gmail.com>)
Responses Re: vacuuming problems continued  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-performance
Antoine <melser.anton@gmail.com> writes:
> We just don't seem to be getting much benefit from autovacuum. Running
> a manual vacuum seems to still be doing a LOT, which suggests to me
> that I should either run a cron job and disable autovacuum, or just
> run a cron job on top of autovacuum.

The default autovac parameters are very unaggressive --- have you
experimented with changing them?  Do you have the FSM set large enough?

            regards, tom lane

pgsql-performance by date:

Previous
From: Antoine
Date:
Subject: vacuuming problems continued
Next
From: "Joao"
Date:
Subject: help me problems with pg_clog file