<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><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 0 10px 10px; border-left:2px solid #C3D9E5; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div style="margin:0 0 10px 0;"> </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" onclick="parent.window.location.href='mailto:felix-kunde@gmx.de'; return false;" target="_blank">felix-kunde@gmx.de</a>> wrote:</div>
<blockquote class="gmail_quote" style="margin: 0.0px 0.0px 0.0px 0.8ex;border-left: 1.0px solid rgb(204,204,204);padding-left: 1.0ex;">
<div>
<div style="font-family: Verdana;font-size: 12.0px;">
<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: 10.0px 5.0px 5.0px 10.0px;padding: 10.0px 0.0px 10.0px 10.0px;border-left: 2.0px solid rgb(195,217,229);">
<div style="margin: 0.0px 0.0px 10.0px;"> </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" onclick="parent.window.location.href='mailto:pocwiard@gmail.com'; return false;" target="_blank">pocwiard@gmail.com</a>> wrote:</div>
<blockquote class="gmail_quote" style="margin: 0.0px 0.0px 0.0px 0.8ex;border-left: 1.0px solid rgb(204,204,204);padding-left: 1.0ex;">
<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" onclick="parent.window.location.href='mailto:postgis-users@lists.osgeo.org'; return false;" 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_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" onclick="parent.window.location.href='mailto:postgis-users@lists.osgeo.org'; return false;" 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" onclick="parent.window.location.href='mailto:postgis-users@lists.osgeo.org'; return false;" 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_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 postgis-users@lists.osgeo.org <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></body></html>