[postgis-users] Multipoint thresold

Nicolas Ribot nicolas.ribot at gmail.com
Fri Jul 2 07:48:33 PDT 2010

> Hi everyone,
> I am using multipoints and while filling them I noticed that there appears
> to be a thresold between 1,100 and 1,200 points per multipoint (no error,
> everything loads fine, just the multipoint geometry columns are empty).
> I haven't found any documentation on this. So, I am wondering whether this
> is a general size restriction or if it depends on the computer you're on as
> well.

No size restriction.

Is it possible you look at your data using pgAdmin ?
If it is the case, pgAdmin is limiting the number of characters when
displaying tables.

try a select st_numGeometries(geom) to check all the points are added
to the multi object.
Or use psql to see the data.


More information about the postgis-users mailing list