On Sat, Oct 16, 2010 at 05:33:37PM +1100, Brett Henderson wrote: > - Updated the pgsql schema (now version 6) to move all tags into hstore > columns, add a ways.nodes column and CLUSTER the nodes and ways tables. > Significant performance increases.
Is there some magic involved or do you just call CLUSTER after the import? When I tested CLUSTER it helped with reads, but creating the cluster was very expensive. Jochen -- Jochen Topf joc...@remote.org http://www.remote.org/jochen/ +49-721-388298 _______________________________________________ osmosis-dev mailing list osmosis-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/osmosis-dev