[Tile-serving] osm2pgsql, -G and multipolygons
Paul Norman
penorman at mac.com
Wed Mar 12 07:20:52 UTC 2014
I hope no one minds my announcements of me having written up my
benchmarking work, but I figure this is the best place to announce
it and stimulate discussion.
I wrote up some of my benchmarking on the -G option for osm2pgsql,
and what its splitting MULTIPOLYGONs into POLYGONs does:
http://www.paulnorman.ca/blog/2014/03/osm2pgsql-multipolygons/
The short version is it decreases performance by 5.5% overall.
It has minimal impact on zooms 13 and above, but has more impact
on the higher zooms, of which most of the workload is.
I'm doing some investigations to see if there are ways to recover
some of the lost performance, but nothing to report yet.
More information about the Tile-serving
mailing list