Re: [postgis-users] Advice on space efficient grid indexing

2016-09-29 Thread Arnaud L.
Le 29/09/2016 à 10:59, Martijn Meijers a écrit : Would the idea of the Spatial Location Code help you? http://www.gdmc.nl/oosterom/slc.pdf Hi Martijn, thanks a lot for your answer. That's quite a long read but it looks very interesting, I'll look at this tomorrow. Thanks in advance ! I hav

Re: [postgis-users] Advice on space efficient grid indexing

2016-09-29 Thread Martijn Meijers
Hi Arnaud, Would the idea of the Spatial Location Code help you? http://www.gdmc.nl/oosterom/slc.pdf Martijn On 29-09-16 10:49, Arnaud L. wrote: Le 29/09/2016 à 10:11, Arnaud L. a écrit : What would be a more efficient way to store this cell coordinates so that disk usage would be limited

Re: [postgis-users] Advice on space efficient grid indexing

2016-09-29 Thread Arnaud L.
Le 29/09/2016 à 10:11, Arnaud L. a écrit : What would be a more efficient way to store this cell coordinates so that disk usage would be limited and accessing the rows would be using the index efficiently ? Using a point geometry would not be space efficient I believe, and it seems overkill since

[postgis-users] Advice on space efficient grid indexing

2016-09-29 Thread Arnaud L.
Hi all We have quite large tables containing geometries (one table per geometry type), and we need to use them in a legacy application that has it's own locking system. Basically, rows are locked on a grid basis (i.e. all geometries in a square cell are locked at once, the size of the cell can