> 00 23 * * 1-5 /usr/local/pgsql/bin/psql supre -c "vacuum analyze;"
Also, this is bad - you are not vacuuming all your databases, which will
cause you data loss one day with transaction wraparound. Use the
vacuumdb utility that comes with PostgreSQL instead.
In response to
pgsql-performance by date
|Next:||From: Rodrigo Moreno||Date: 2005-02-18 14:54:34|
|Subject: Degradation of postgres 7.4.5 on FreeBSD/CygWin|
|Previous:||From: Christopher Kings-Lynne||Date: 2005-02-18 14:51:42|
|Subject: Re: RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin|