Postgres Pro
Downloads
Home   >   mailing lists

Vacuum question - Mailing list pgsql-novice

From Patrick Hatcher
Subject Vacuum question
Date
Msg-id OFE2DEFCC7.6362AD80-ON88256C56.0045845C-88256C56.0045D977@fds.com
Whole thread Raw
Responses Re: Vacuum question
List pgsql-novice
Tree view 
Each night I truncate and refresh around 90% of our database.  After each
table is re-populated, I Vacuum Analyze.  Should I also do a Vacuum Full on
each of these tables? And if so, should I do the full after I've truncated
all the data or after I've repopulated and before my vacuum analyze?

TIA

Patrick Hatcher
Macys.Com
Legacy Integration Developer

pgsql-novice by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: char() or varchar() for frequently used column
Next
From: Tom Lane
Date:
Subject: Re: information