On Wed, Nov 26, 2008 at 10:21 AM, Rafael Domiciano
> I'm not using autovacuum. Regular vacuum goes ok.
> To see the last 10 lines of verbose i will need to run vacuum tonight
> If a run a reindex before the vacuum full, increase the "speed" of doing
> vacuum? I found something about it googling.
You should look into enabling autovac. You can set the sleep
parameter to 10 or 20 to keep it from hogging your I/O bandwidth.
Also, reindex AFTER the vacuum full, not before.
In response to
pgsql-admin by date
|Next:||From: Jan-Peter Seifert||Date: 2008-11-26 18:39:18|
|Subject: Re: Vacuum Problems|
|Previous:||From: Vishal Arora||Date: 2008-11-26 17:25:11|
|Subject: Re: PgAgent Job Scehduler is NOT running|