Postgres Pro
Downloads
Home   >   mailing lists

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..  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
List pgsql-general
Tree view 
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