2

I have a PostGIS table with 2M rows, all Points. I'm creating tiles from the data, but it's quite slow.

Although I have the normal geometry indexes enabled on the table, I wonder if it's possible to index better according to tile boundaries (which are alwayws the same).

Or is the normal geom_idx taking care of this already?

  • 2
    did you cluster on the geom_idx? – Ian Turton Jul 31 '15 at 15:18
  • No, I don't know what that means. – knutole Jul 31 '15 at 18:46
1

It is in fact possible. And it may even cluster a little better (especially for polygons). I recommend using a quadtile key/quadkey/quadtree system to refer to the item's tile. See http://www.maptiler.org/google-maps-coordinates-tile-bounds-projection/ for some visualization, well documented code, and explanation of different ways to refer to and calculate a tile.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.