Thank you all very much I wil lcheck that.
kind regards Pawel On Fri, Mar 22, 2019 at 2:49 AM Felix Kunde <[email protected]> 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 12:25 PM Felix Kunde <[email protected]> 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 <[email protected]> >> 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 >>> [email protected] >>> https://lists.osgeo.org/mailman/listinfo/postgis-users >> >> >> >> -- >> Darafei Praliaskouski >> Support me: http://patreon.com/komzpa >> _______________________________________________ postgis-users mailing >> list [email protected] >> https://lists.osgeo.org/mailman/listinfo/postgis-users >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> https://lists.osgeo.org/mailman/listinfo/postgis-users > > > > -- > Darafei Praliaskouski > Support me: http://patreon.com/komzpa > _______________________________________________ postgis-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users > _______________________________________________ > postgis-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
