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.
2008/11/26 Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
> 2008/11/26 Rafael Domiciano <rafael(dot)domiciano(at)gmail(dot)com>:
> > The database has around 40 Gb.
> > If I not use vacuum full everyday the database get very slow.
> > There is no deadlock on the database.
> You didn't mention if you were using autovacuum or not. You also
> didn't mention whether or not you'd tried regular vacuums if for some
> reason you can't use autovacuum. Vacuum full is very intrusive and
> can cause index bloat. It's more of a repair operation than a routine
> maintenance one.
> What do the last 10 or so lines of vacuum verbose run as a super user say?
In response to
pgsql-admin by date
|Next:||From: Vishal Arora||Date: 2008-11-26 17:25:11|
|Subject: Re: PgAgent Job Scehduler is NOT running|
|Previous:||From: Scott Marlowe||Date: 2008-11-26 15:40:41|
|Subject: Re: Vacuum Problems|