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

From Steinar H. Gunderson
Subject Re: Degradation of postgres 7.4.5 on FreeBSD/CygWin
Date
Msg-id 20050218140850.GA16919@uio.no
Whole thread Raw
In response to Degradation of postgres 7.4.5 on FreeBSD/CygWin  ("Rodrigo Moreno" <rodrigo.miguel@terra.com.br>)
List pgsql-performance
On Fri, Feb 18, 2005 at 11:54:34AM -0300, Rodrigo Moreno wrote:
> 00 23 * * 1-5 /usr/local/pgsql/bin/psql supre -c "vacuum analyze;"
>>>/dev/null 2>&1

Isn't vacuum once a day a bit too little with heavy activity? You should
probably consider autovacuum.

> 00 23 * * 6 /usr/local/pgsql/bin/psql supre -c "reindex database supre;"
>>>/dev/null 2>&1

REINDEX DATABASE does (AFAIK) only index the indexes on the system tables in
the database.

/* Steinar */
--
Homepage: http://www.sesse.net/

pgsql-performance by date:

Previous
From: "Rodrigo Moreno"
Date:
Subject: Degradation of postgres 7.4.5 on FreeBSD/CygWin
Next
From: Tom Lane
Date:
Subject: Re: Effects of IDLE processes