<div dir="ltr">Thank you all very much<div><br></div><div>I wil lcheck that. <br clear="all"><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><br></div><div>kind regards</div><div>Pawel </div></div></div></div></div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Mar 22, 2019 at 2:49 AM Felix Kunde <<a href="mailto:felix-kunde@gmx.de">felix-kunde@gmx.de</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div style="font-family:Verdana;font-size:12px"><div>I thought so. So it's an option for Pawel if he's really only working in one area of the pointcloud. Sounds unlikely, but good to know anyway :)
<div>
<div name="quote" style="margin:10px 5px 5px 10px;padding:10px 0px 10px 10px;border-left:2px solid rgb(195,217,229)">
<div style="margin:0px 0px 10px"> </div>
<div name="quoted-content">
<div class="gmail_quote">
<div class="gmail_attr">On Fri, Mar 22, 2019 at 12:25 PM Felix Kunde <<a href="mailto:felix-kunde@gmx.de" target="_blank">felix-kunde@gmx.de</a>> wrote:</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<div style="font-family:Verdana;font-size:12px">
<div>
<div>yup, probably indexing.</div>
<div> </div>
<div>If it's a big pointcloud a BRIN index can make sense.</div>
<div>For some guidance, I just gave a talk on this subject recently: <a href="https://slides.com/fxku/postgis-indexing#/" target="_blank">https://slides.com/fxku/postgis-indexing#/</a></div>
<div>More details here: <a href="https://postgis.net/docs/manual-2.5/using_postgis_dbmanagement.html#idm2246" target="_blank">https://postgis.net/docs/manual-2.5/using_postgis_dbmanagement.html#idm2246</a></div>
<div> </div>
<div>Btw: I was wondering if PostGIS supports partial indexes, e.g. CREATE INDEX ... WHERE geom && <area_of_interest>; ?</div>
<div>So, that the spatial index doesn't get too big. Will do a test myself this weekend but maybe somebody can already tell yes or no.</div>
<div> </div>
<div>Cheers</div>
<div>Felix</div>
<div> </div>
<div style="margin:10px 5px 5px 10px;padding:10px 0px 10px 10px;border-left:2px solid rgb(195,217,229)">
<div style="margin:0px 0px 10px"> </div>
<div>
<div>
<div>Hi,
<div> </div>
<div>Thing you explain may be called Indexing. Have a look here:</div>
<div><a href="http://postgis.net/workshops/postgis-intro/indexing.html" target="_blank">http://postgis.net/workshops/postgis-intro/indexing.html</a> </div>
</div>
</div>
<div class="gmail_quote">
<div class="gmail_attr">On Thu, Mar 21, 2019 at 10:11 PM Pawel Pocwiardowski <<a href="mailto:pocwiard@gmail.com" target="_blank">pocwiard@gmail.com</a>> wrote:</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>Hi
<div> </div>
<div>I am complete newbe in postGIS so I appology for stupid question. </div>
<div> </div>
<div>Is there a mechanism in PostGIS's insert selective query which will limit the search to some approximate area instead of searching through all data in database? </div>
<div> </div>
<div>Say, we have large (maybe global) coverage of some point cloud data but user is interested is searching and replacing only specific small part of the data in specific region and prevent the database from search through all the data. </div>
<div>Is there a mechanism (or structure of the database tables) which facilitates that?</div>
<div> </div>
<div>Is there any white paper to refer to?</div>
<div> </div>
<div>Thanks in advance</div>
<div> </div>
<div>Pawel</div>
<div> </div>
</div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote>
</div>
<div> </div>
--
<div class="gmail-m_-7319785002364951341gmail-m_4042739827412923177gmail_signature">
<div>
<div>
<div>Darafei Praliaskouski</div>
<div>Support me: <a href="http://patreon.com/komzpa" target="_blank">http://patreon.com/komzpa</a></div>
</div>
</div>
</div>
_______________________________________________ postgis-users mailing list <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a> <a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></div>
</div>
</div>
</div>
</div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote>
</div>
<div> </div>
--
<div class="gmail-m_-7319785002364951341gmail_signature">
<div>
<div>
<div>Darafei Praliaskouski</div>
<div>Support me: <a href="http://patreon.com/komzpa" target="_blank">http://patreon.com/komzpa</a></div>
</div>
</div>
</div>
_______________________________________________ postgis-users mailing list <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a> <a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></div>
</div>
</div>
</div></div></div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div>