Re: vacuuming problems continued

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Antoine <melser(dot)anton(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: vacuuming problems continued
Date: 2006-06-01 15:05:55
Message-ID: 12384.1149174355@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Antoine <melser(dot)anton(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Joao 2006-06-01 17:17:50 help me problems with pg_clog file
Previous Message Antoine 2006-06-01 11:54:08 vacuuming problems continued