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(dot)janes(at)gmail(dot)com
Subject: Re: Does this perf output seem 'normal'?
Date: 2016-04-27 15:45:58
Message-ID: CABoFc_i+vq5-wfmTXUSL8T+iLex48BzFAz3mFvOtRw4J2jJ9cg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2016-04-27 15:56:55 Re: BDR Alter table failing
Previous Message Alvaro Aguayo Garcia-Rada 2016-04-27 15:43:59 Re: BDR Alter table failing