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?

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

1 Answer 1

Reset to default
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.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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