Skip site navigation (1) Skip section navigation (2)

Vacuum question

From: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Vacuum question
Date: 2002-10-18 12:42:42
Message-ID: OFE2DEFCC7.6362AD80-ON88256C56.0045845C-88256C56.0045D977@fds.com (view raw or flat)
Thread:
Lists: pgsql-novice
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




Responses

pgsql-novice by date

Next:From: Bruno Wolff IIIDate: 2002-10-18 12:51:03
Subject: Re: char() or varchar() for frequently used column
Previous:From: Oliver ElphickDate: 2002-10-18 11:11:39
Subject: Re: What is postgres password.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group