[postgis-users] Question on topology

Sandro Santilli strk at kbt.io
Wed Jul 13 04:15:38 PDT 2016


On Wed, Jul 13, 2016 at 01:05:41PM +0200, Neumann, Andreas wrote:

> Yes - I will try that next - loading it in chunks. But wouldn't it miss
> out on some of the neighbourpolygons then if I use such subsets based on
> pkey? 

The final goal is importing all of your geometries, so eventually
neighbours would be added soon or late.

If you prefer loading in order you could use use
ORDER BY geom OFFSET $1 LIMIT $2, which would insert
inputs from left to right ...

--strk;


More information about the postgis-users mailing list