Hello,
I am struggling with a problem while using postgres as the datasource.
I have specified multiple layers in a single xml file. I have written 10
xmls for 10 zoom levels. Each of my xml file is connecting to postgres for
fetching out the data. These xmls are having more than 12 defined layers.
So, there are 12 postgis connections specified in each xml.
Example of a xml layer :
<snip>
<Layer name="us_boundary" status="on">
<StyleName>us_boundary</StyleName>
<Datasource>
<Parameter name="type">postgis</Parameter>
<Parameter name="host">xxx.xx.xxx.xxx</Parameter>
<Parameter name="dbname">MY_DATA</Parameter>
<Parameter name="user">ritesh</Parameter>
<Parameter name="password">ambastha</Parameter>
<Parameter name="table">(select * from us_po_boundary) as
us_boundary</Parameter>
</Datasource>
</Layer>
</snip>
I am calling these xmls from my tilecache program for dynamically generating
the map images. It causes a huge extra load on the server and opens up a
long connection queue. I have configured postgres and pgpool. Also, I have
indexed my tables.
Please let me know if there is a way to improvise the situation. I was
satisfied with 'connection=defer' function of mapserver. I don't have any
idea to implement this in mapnik.
Your help will be highly appreciated.
Thanks,
Ritesh Ambastha
--
View this message in context:
http://www.nabble.com/Multiple-postgres-connections-call-from-mapnik-xml-tp22928055p22928055.html
Sent from the Mapnik - Users mailing list archive at Nabble.com.
_______________________________________________
Mapnik-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/mapnik-users
