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: (view raw, whole thread or download thread mbox)
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?


Patrick Hatcher
Legacy Integration Developer


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-2017 The PostgreSQL Global Development Group