Vacuum question..

From: "Williams, Travis L, NPONS" <tlw(at)att(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Vacuum question..
Date: 2002-10-01 00:08:11
Message-ID: AB815D267EC31A4693CC24D234F82916028608B8@ACCLUST02EVS1.ugd.att.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 all of 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2002-10-01 00:53:43 Re: composite types in 7.3
Previous Message Joe Conway 2002-09-30 23:46:37 Re: composite types in 7.3