Bob Dusek <redusek(at)gmail(dot)com> wrote:
> How do I learn more about the actual lock contention in my db?
> Lock contention makes some sense. Each of the 256 requests are
> relatively similar. So, I don't doubt that lock contention could
> be an issue. I just don't know how to observe it or correct it.
> It seems like if we have processes that are contending for locks,
> there's not much we can do about it.
I'm not sure what the best way would be to measure it, but in prior
discussions the general mood seemed to be that if you had so many
active sessions that you were running into the issue, the best
solution was to use a connection pool to avoid it.
-Kevin