[postgis-users] Fwd: Huge Multipolygon cannot be inserted to database

[Christoph Kleih]

Dear Paul,

I applied your advice and now I am happy to see my sophisticated polygons
in the database :-)

Thank you!

Cheers,
Christoph

2015-01-09 0:42 GMT+01:00 Paul Ramsey <pramsey at cleverelephant.ca>:

> You have created an index on your geometry column using something like
>
>   CREATE INDEX myindex ON mytable (geom);
>
> This has created a b-tree index, which is limited in the object size
> it can handle (and won't answer spatial questions efficiently in any
> event).  Drop it, and replace with a GIST index,
>
>   DROP INDEX myindex;
>   CREATE INDEX myindex ON mytable USING GIST (geom);
>
> P
>
> On Thu, Jan 8, 2015 at 12:35 PM, Christoph Kleih
> <christoph.kleih at googlemail.com> wrote:
> >
> > Dear postgis users,
> >
> > I am working with postgis in order to catalogue lots of datasets.
> > I just store the filenames and different attributes to GeoTIFF products.
> > Additionally I want to store a geometry object that contains a
> > Multipolygon. The multipolygon shows where I can find data within the
> > GeoTIFF.
> >
> > This Multipolygon can contain up to 2000 Polygons. The WKT insert can
> > have a few hundred thousand characters.
> >
> > I want to insert the data via a python script.
> >
> > When I try to do the insert with the pgadmin, I get the following error.
> > """
> > ERROR:  index row requires 181440 bytes, maximum size is 8191
> > """
> >
> > Is there a solution to insert such large polygons? And if yes, how can I
> > do that and is it still possible to create queries that run over
> > thousands of datasets and ask whether a point, or polygon is inside my
> > dataset. (Inside of the multipolygon).
> >
> > I appreciate any hint!
> >
> > Thank you,
> > Christoph
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150109/4c5c4196/attachment.html>