[postgis-users] postgis geometry sizes

Markus Schaber schabi at logix-tt.com
Tue Mar 7 11:28:21 PST 2006

Hi, Eric,

Eric Lam wrote:

> I have a set of data [multilinestrings]. The data is about 2gig. I have
> processed the data and the data is now 11gig on disc, using the
> realtion_size() command. I have counted the number of points and the
> 11gig data set has 1/4 the number of points as the 2gig data set. Does
> anyone know why this is? I am running short on disc space.

Which postgis and postgres version are you using?

Did you VACUUM or VACUUM FULL the table?

Do you have indices? Did you try REINDEX?

Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

More information about the postgis-users mailing list