[postgis-users] postgis geometry sizes

Michael Fuhr mike at fuhr.org
Sun Mar 5 15:04:16 PST 2006

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

More information about the postgis-users mailing list