<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
Hi All,
<div class=""><br class="">
</div>
<div class="">I’m testing MapProxy for seeding tiles to a cache using a mapnik source which has multiple PostGIS layers. I’ve noticed that PostGIS connections are not being reused between mapnik tile render sessions. Establishing a new PG connection per session
is going to add overhead when rendering millions of tiles. </div>
<div class=""><br class="">
</div>
<div class="">Is anyone aware of this issue or do I need to do extra configuration? </div>
<div class=""><br class="">
</div>
<div class="">My command to seed is:</div>
<div class=""><br class="">
</div>
<div class="">mapproxy-seed -f maptiles.yml -s seeds.yml -c 4</div>
<div class=""><br class="">
</div>
<div class="">My mapnik 3.0.12 XML is using the default PostGIS parameters and should reuse connections according to the documentation:</div>
<div class=""><br class="">
</div>
<div class=""><a href="http://mapnik.org/docs/v2.1.0/api/python/mapnik-module.html" class="">http://mapnik.org/docs/v2.1.0/api/python/mapnik-module.html</a></div>
<div class=""><br class="">
</div>
<div class="">
<div class=""> <StyleName>Bridge_Topo</StyleName></div>
<div class=""> <Datasource></div>
<div class=""> <Parameter name="type"><![CDATA[postgis]]></Parameter></div>
<div class=""> <Parameter name="table"><![CDATA[(Select * From bridge) AS Bridge]]></Parameter></div>
<div class=""> <Parameter name="key_field"><![CDATA[]]></Parameter></div>
<div class=""> <Parameter name="geometry_field"><![CDATA[]]></Parameter></div>
<div class=""> <Parameter name="extent_cache"><![CDATA[auto]]></Parameter></div>
<div class=""> <Parameter name="extent"><![CDATA[18588719.8615001,-5939257.42937042,19869879.1530354,-4093884.06936018]]></Parameter></div>
<div class=""> <Parameter name="dbname"><![CDATA[nz_data]]></Parameter></div>
<div class=""> <Parameter name="host"><![CDATA[localhost]]></Parameter></div>
<div class=""> <Parameter name="port"><![CDATA[5432]]></Parameter></div>
<div class=""> <Parameter name="user"><![CDATA[postgres]]></Parameter></div>
<div class=""> <Parameter name="password"><![CDATA[postgres]]></Parameter></div>
<div class=""> </Datasource></div>
<div class=""> </Layer></div>
</div>
<div class=""><br class="">
</div>
<div class="">Cheers</div>
<div class="">Jeremy</div>
<div class=""><br class="">
</div>
<br>
<hr>
<font face="Verdana" color="Black" size="2">This message contains information, which may be in confidence and may be subject to legal privilege. If you are not the intended recipient, you must not peruse, use, disseminate, distribute or copy this message. If
you have received this message in error, please notify us immediately (Phone 0800 665 463 or info@linz.govt.nz) and destroy the original message. LINZ accepts no responsibility for changes to this email, or for any attachments, after its transmission from
LINZ. Thank You.<br>
</font>
</body>
</html>