Re: RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Rodrigo Moreno <rodrigo(dot)miguel(at)terra(dot)com(dot)br>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin
Date: 2005-02-18 14:52:48
Message-ID: 42160140.20407@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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.

Chris

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rodrigo Moreno 2005-02-18 14:54:34 Degradation of postgres 7.4.5 on FreeBSD/CygWin
Previous Message Christopher Kings-Lynne 2005-02-18 14:51:42 Re: RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin