Re: Posrgres speed problem

[Ruben Rubio Rey <ruben@xxxxxxxxxxxx>]

Jim C. Nasby wrote:

> On Mon, Jun 12, 2006 at 04:58:49PM +0200, Ruben Rubio Rey wrote:
>  
>
> > $DIREC/vacuumdb -f -v --analyze vacadb 2>&1 | $LOGBIN 
> > $DIRLOGS/%Y-%m-%d_limpieza.log
> > echo "reindex database vacadb;" | $DIREC/psql vacadb 2>&1 | $LOGBIN 
> > $DIRLOGS/%Y-%m-%d_limpieza.log
> > date | $LOGBIN $DIRLOGS/%Y-%m-%d_limpieza.log
> >    
>
> Ugh. Is there some reason you're not using the built-in autovacuum?
How do I execute built-in autovacuum?