Re: User concurrency thresholding: where do I look? - Mailing list pgsql-performance

From David Boreham
Subject Re: User concurrency thresholding: where do I look?
Date
Msg-id 46A17E02.2090807@boreham.org
Whole thread Raw
In response to Re: User concurrency thresholding: where do I look?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: User concurrency thresholding: where do I look?
List pgsql-performance
Tom Lane wrote:
> Having malloc/free use
> an internal mutex is necessary in multi-threaded programs, but the
> backend isn't multi-threaded.
>
Hmm...confused. I'm not following why then there is contention for the
mutex.
Surely this has to be some other mutex that is in contention, not a heap
lock ?

It'd be handy to see the call stack for the wait state -- if the thing
is spending
a significant proportion of its time in contention it should be easy to
get that with
a simple tool such as pstack or a debugger.



pgsql-performance by date:

Previous
From: "Gavin M. Roy"
Date:
Subject: Re: Postgres configuration for 64 CPUs, 128 GB RAM...
Next
From: Tom Lane
Date:
Subject: Re: User concurrency thresholding: where do I look?