Vacuum question.. - Mailing list pgsql-general

From Williams, Travis L, NPONS
Subject Vacuum question..
Date
Msg-id AB815D267EC31A4693CC24D234F82916028608B8@ACCLUST02EVS1.ugd.att.com
Whole thread Raw
Responses Re: Vacuum question..
List pgsql-general
I have a DB that's about 1000 rows and 100 columns with 97 of them being updated every 20-30 min.  This DB is basically
allof the data that I poll off of 1000 different machines thats used by different scripts.  How often should I run
Vacuum? Would I be better off doing it every time after I do my updates? 

Travis

pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: composite types in 7.3
Next
From: Jeff Davis
Date:
Subject: Re: composite types in 7.3