[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Fwd: Huge Multipolygon cannot be inserted to database
From: Christoph Kleih <christoph.kleih () googlemail ! com>
Date: 2015-01-09 10:30:32
Message-ID: CAA78MoMbS2oDhuu1TR-WaJAi3t7W7K_bvYgYtU9wFAC=QnxFbQ () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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@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@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@lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
[Attachment #5 (text/html)]
<div dir="ltr"><div><div>Dear Paul,<br><br></div>I applied your advice and now I am \
happy to see my sophisticated polygons in the database :-)<br><br>Thank \
you!<br><br></div>Cheers,<br>Christoph<br></div><div class="gmail_extra"><br><div \
class="gmail_quote">2015-01-09 0:42 GMT+01:00 Paul Ramsey <span dir="ltr"><<a \
href="mailto:pramsey@cleverelephant.ca" \
target="_blank">pramsey@cleverelephant.ca</a>></span>:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div class="HOEnZb"><div class="h5">You have created an index \
on your geometry column using something like<br> <br>
CREATE INDEX myindex ON mytable (geom);<br>
<br>
This has created a b-tree index, which is limited in the object size<br>
it can handle (and won't answer spatial questions efficiently in any<br>
event). Drop it, and replace with a GIST index,<br>
<br>
DROP INDEX myindex;<br>
CREATE INDEX myindex ON mytable USING GIST (geom);<br>
<br>
P<br>
<br>
On Thu, Jan 8, 2015 at 12:35 PM, Christoph Kleih<br>
<<a href="mailto:christoph.kleih@googlemail.com">christoph.kleih@googlemail.com</a>> \
wrote:<br> ><br>
> Dear postgis users,<br>
><br>
> I am working with postgis in order to catalogue lots of datasets.<br>
> I just store the filenames and different attributes to GeoTIFF products.<br>
> Additionally I want to store a geometry object that contains a<br>
> Multipolygon. The multipolygon shows where I can find data within the<br>
> GeoTIFF.<br>
><br>
> This Multipolygon can contain up to 2000 Polygons. The WKT insert can<br>
> have a few hundred thousand characters.<br>
><br>
> I want to insert the data via a python script.<br>
><br>
> When I try to do the insert with the pgadmin, I get the following error.<br>
> """<br>
> ERROR: index row requires 181440 bytes, maximum size is 8191<br>
> """<br>
><br>
> Is there a solution to insert such large polygons? And if yes, how can I<br>
> do that and is it still possible to create queries that run over<br>
> thousands of datasets and ask whether a point, or polygon is inside my<br>
> dataset. (Inside of the multipolygon).<br>
><br>
> I appreciate any hint!<br>
><br>
> Thank you,<br>
> Christoph<br>
</div></div>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" \
target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br> \
</blockquote></div><br></div>
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic