I have now done a recording for 60 seconds during a batch of 1000 requests and posted the results on a new issue on the Mapnik repo. Although Postgres still comes out on top in the perf results I struggle to believe this is a Postgres issue. But, if anyone is curious, the issue is here: https://github.com/mapnik/mapnik/issues/3414 I may come back here if I don't have luck with the Mapnik developers. All the best Peter 3XE P: 01326 567155 M: 07770 693662 A: 3XE Ltd Tremough Innovation Centre PENRYN TR10 9TA 3XE Ltd · Registered in England and Wales · 9356871 On 27 April 2016 at 16:45, Peter Devoy <peter@xxxxxxxxx> wrote: >> If you really want to profile this, you should fire it off in a tight loop, using wget or ab2 or curl. > > Thanks Jeff, that sounds like a smart idea. I will try later when I > have access to the server. > >>Hi! What do you want to see in perf stats? Maybe you can explain your problem more in details? > > Hi Alex ) I am hoping to find out which function calls are taking the > longest because to the code is taking too long to only parse a small > XML file and do a few quick database queries. The last version of > this software was able to do a lot more in the same period of time. I > realise this most likely a client software issue but was hoping it may > be obvious whether Mapnik is spending too much time with Postgres. > > Unfortunately I may just have to try again to build Mapnik from source > so that I can get debugging/profiling output, etc. -- I was hoping to > avoid it because it is quite painful. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
