Re: Does this perf output seem 'normal'? - Mailing list pgsql-general

From Peter Devoy
Subject Re: Does this perf output seem 'normal'?
Date
Msg-id CABoFc_i+vq5-wfmTXUSL8T+iLex48BzFAz3mFvOtRw4J2jJ9cg@mail.gmail.com
Whole thread Raw
In response to Re: Does this perf output seem 'normal'?  (Alex Ignatov <a.ignatov@postgrespro.ru>)
Responses Re: Does this perf output seem 'normal'?
List pgsql-general
> 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.


pgsql-general by date:

Previous
From: Alvaro Aguayo Garcia-Rada
Date:
Subject: Re: BDR Alter table failing
Next
From: Craig Ringer
Date:
Subject: Re: BDR Alter table failing