[postgis-users] postgis geometry sizes

[Michael Fuhr]

On Sun, Mar 05, 2006 at 02:44:56PM -0800, Paul Ramsey wrote:
> header).  As a previous poster noted, if you have been doing  
> processing on the data in the table itself, you probably have a large  
> number of dead tuples.  VACUUM FULL your table, then cluster it on an  
> index to reduce it to the minimum possible on-disk size.

If you're going to cluster then you can skip the VACUUM FULL because
clustering removes dead tuples.

-- 
Michael Fuhr