[Tile-serving] Osm2pgsql table partitioning

Sven Geggus lists at fuchsschwanzdomain.de
Mon Jun 3 11:34:54 UTC 2013


Kai Krueger <kakrueger at gmail.com> wrote:

> What would be the most useful partitionings to test this on? What would 
> likely show the biggest speed improvements with the default style sheet?

Talking about polygons this is almost certainly a partition between
buildings and all the rest.

The database queries making low-zoom rendring slow especially on traditional
disks are forests because of the many seeks skipping building polygons in
the area.

> One possibility would be to partition the polygon table into "buillding 
> is null" and "building is not null". That would split the tables roughly 
> 6:1, and many of the slower queries in the default stylesheet already 
> have a "where building is null" clause.

I would go for this.

Sven


-- 
"The only thing we have to fear is fear itself" (Franklin D. Roosevelt)


/me is giggls at ircnet, http://sven.gegg.us/ on the Web



More information about the Tile-serving mailing list