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 <[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
