Vacuum full - Mailing list pgsql-general

From Andrew Bartley
Subject Vacuum full
Date
Msg-id 003a01c28536$9f4395d0$3200a8c0@abartleypc
Whole thread Raw
List pgsql-general

We are using postgres 7.2

 

Can anyone tell me what the ramifications are if I do not vacuum full the whole DB?

 

Say if I was to selectively vacuum all of the PG tables, and only some of the Application tables.

 

We have a number of tables that are effectively archive type tables.  They are large, but do not change. If

I was to vacuum these tables on a regular basis, it would add a significant portion of time to the housekeeping process.

 

Thanks
 
Andrew
 
 
 
 

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Buffers and MacOS X
Next
From: Justin Clift
Date:
Subject: Re: Vacuum full