I believe the library is spawning a new connection for each query so
that makes perfect sense.
I will see what improvements can be made at the application layer and
look at using pgbouncer if required =)
Thank you for sharing your knowledge!
--
Sent via pgsql-general mailing list (pgsql-genera
On 28.04.2016 17:50, Peter Devoy wrote:
Also do you know that in perf report second column is the total cpu time
share and not the first
Thank you, I did notice they did not add up -- that makes more sense now.
Can you expand node from perf report
Yes, my pleasure. I added "--call-graph
>Also do you know that in perf report second column is the total cpu time
>share and not the first
Thank you, I did notice they did not add up -- that makes more sense now.
>Can you expand node from perf report
Yes, my pleasure. I added "--call-graph fractal,2,callee" to the
command, hopefully
On 28.04.2016 1:11, Peter Devoy wrote:
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 anyo
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://g
> 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 deta
On 27.04.2016 2:27, Peter Devoy wrote:
Hi all,
I am trying to work out why a piece of software, Mapnik, is executing
slowly. All it is doing is loading a config file which causes about
12 preparation queries (i.e. with LIMIT 0) to be executed. I can see
from pg_stat_statements these only tak
On Apr 26, 2016 4:29 PM, "Peter Devoy" wrote:
>
> Hi all,
>
> I am trying to work out why a piece of software, Mapnik, is executing
> slowly. All it is doing is loading a config file which causes about
> 12 preparation queries (i.e. with LIMIT 0) to be executed. I can see
> from pg_stat_statemen
Hi all,
I am trying to work out why a piece of software, Mapnik, is executing
slowly. All it is doing is loading a config file which causes about
12 preparation queries (i.e. with LIMIT 0) to be executed. I can see
from pg_stat_statements these only take ~1ms in their totality.
So next I ran "p