Postgres Pro
Downloads
Home   >   mailing lists

Re: RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin
Date
Msg-id 42160140.20407@familyhealth.com.au
Whole thread Raw
In response to RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin  ("Rodrigo Moreno" <rodrigo.miguel@terra.com.br>)
Responses RES: RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin  ("Rodrigo Moreno" <rodrigo.miguel@terra.com.br>)
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin
Next
From: Tom Lane
Date:
Subject: Re: RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin