Re: [postgis-users] Point cloud insert and selective spacial location

Thank you all very much I wil lcheck that. kind regards Pawel On Fri, Mar 22, 2019 at 2:49 AM Felix Kunde wrote: > 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 :) > > > On Fri, Mar 22, 2019 at 1

Re: [postgis-users] Point cloud insert and selective spacial location

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 :)     On Fri, Mar 22, 2019 at 12:25 PM Felix Kunde wrote: yup, probably indexing.   If it's a big pointcloud a BRIN index ca

Re: [postgis-users] Point cloud insert and selective spacial location

PostGIS can do partial indexes, but because of how Postgres infrastructure works you will need to drag the geom && clause into all queries. On Fri, Mar 22, 2019 at 12:25 PM Felix Kunde wrote: > yup, probably indexing. > > If it's a big pointcloud a BRIN index can make sense. > For some guidance

Re: [postgis-users] Point cloud insert and selective spacial location

yup, probably indexing.   If it's a big pointcloud a BRIN index can make sense. For some guidance, I just gave a talk on this subject recently: https://slides.com/fxku/postgis-indexing#/ More details here: https://postgis.net/docs/manual-2.5/using_postgis_dbmanagement.html#idm2246   Btw: I w

Re: [postgis-users] Point cloud insert and selective spacial location

Hi, Thing you explain may be called Indexing. Have a look here: http://postgis.net/workshops/postgis-intro/indexing.html On Thu, Mar 21, 2019 at 10:11 PM Pawel Pocwiardowski wrote: > Hi > > I am complete newbe in postGIS so I appology for stupid question. > > Is there a mechanism in PostGIS's i

[postgis-users] Point cloud insert and selective spacial location

Hi I am complete newbe in postGIS so I appology for stupid question. 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? Say, we have large (maybe global) coverage of some point cloud da