[Mapnik-users] Mapnik and PostgreSQL
aronbierbaum at gmail.com
Wed Apr 16 16:31:11 CEST 2008
First I would like to say that I am very impressed with the
improvements that Mapnik has made since the last time I looked into
using it. I think that there is a lot of potential to get some great
looking maps. I am currently trying to use Mapnik to render road data
for the entire US. The data is stored in three different PostGIS
tables. Major highways, secondary highways, and streets. Each table
has a func_class associated with it that seems to cross between major
and secondary highways (1-5). At first I tried to render all major
highways in the US and got very slow performance (30 seconds). I then
tried to create a rule that filtered the major highways on the class
'1'. This query seemed to perform just as slow, and returned the same
number of records. My questions are:
How should I best organize my data to get the best performance?
Does Mapnik do SQL queries on column values contained in the filters?
Does the performance that I am seeing make sense. My major highway
table has 1,124,813 rows for the entire US?
More information about the Mapnik-users