Re: Does this perf output seem 'normal'?

From: Peter Devoy <peter(at)3xe(dot)co(dot)uk>
To: Alex Ignatov <a(dot)ignatov(at)postgrespro(dot)ru>
Cc: "Psql_General (E-mail)" <pgsql-general(at)postgresql(dot)org>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Subject: Re: Does this perf output seem 'normal'?
Date: 2016-04-27 22:11:21
Message-ID: CABoFc_hMG4roY+K5Q0v6HnDfrakS8Tm2eF3uRLce55twpsL9jQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)3xe(dot)co(dot)uk> 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2016-04-27 22:30:57 Re: CREATE EXTENSION without superuser access
Previous Message Adrian Klaver 2016-04-27 21:47:59 Re: CREATE EXTENSION without superuser access