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:
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 advancePawel
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
