[postgis-users] postgis geometry sizes
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.
More information about the postgis-users