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

[Darafei "Komяpa" Praliaskouski]

PostGIS can do partial indexes, but because of how Postgres infrastructure
works you will need to drag the geom && <area_of_interest> clause into all
queries.

On Fri, Mar 22, 2019 at 12:25 PM Felix Kunde <felix-kunde at gmx.de> wrote:

> 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 was wondering if PostGIS supports partial indexes, e.g. CREATE
> INDEX ... WHERE geom && <area_of_interest>; ?
> 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.
>
> Cheers
> Felix
>
>
> 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 <pocwiard at gmail.com>
> wrote:
>
>> 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 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.
>> Is there a mechanism (or structure of the database tables) which
>> facilitates that?
>>
>> Is there any white paper to refer to?
>>
>> Thanks in advance
>>
>> Pawel
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
>
> --
> Darafei Praliaskouski
> Support me: http://patreon.com/komzpa
> _______________________________________________ postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users



-- 
Darafei Praliaskouski
Support me: http://patreon.com/komzpa
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190322/a242922c/attachment.html>