Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group