[postgis-users] File size in Postgis and native shape file

YC Nyon ycnyon at pd.jaring.my
Mon Oct 21 16:52:54 PDT 2002


I compared a shape theme size in its native form and Postgis format

Native form (including shp, shx, dbf) = 1,093,632 bytes
Postgis = 5,730,356 bytes
(using the php query "select sum(mem_size(the_geom)) from pm2")

I was expecting that the postgis size would be larger, but this is quite a
big ratio.

Anyone mind commenting on this?

Nyon





More information about the postgis-users mailing list