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

From Tom Lane
Subject Re: User concurrency thresholding: where do I look?
Date
Msg-id 12686.1184865938@sss.pgh.pa.us
Whole thread Raw
In response to Re: User concurrency thresholding: where do I look?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: User concurrency thresholding: where do I look?
Re: User concurrency thresholding: where do I look?
List pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
> Alvaro,
>> Have you messed with max_connections and/or max_locks_per_transaction
>> while testing this?  The lock table is sized to max_locks_per_xact times
>> max_connections, and shared memory hash tables get slower when they are
>> full.  Of course, the saturation point would depend on the avg number of
>> locks acquired per user, which would explain why you are seeing a lower
>> number for some users and higher for others (simpler/more complex
>> queries).

> That's an interesting thought.  Let me check lock counts and see if this is
> possibly the case.

AFAIK you'd get hard failures, not slowdowns, if you ran out of lock
space entirely; and the fact that you can continue the curve upwards
says that you're not on the edge of running out.  However I agree that
it's worth experimenting with those two parameters to see if the curve
moves around at all.

Another resource that might be interesting is the number of open files.

Also, have you tried watching vmstat or local equivalent to confirm that
the machine's not starting to swap?

            regards, tom lane

pgsql-performance by date:

Previous
From: "Claus Guttesen"
Date:
Subject: Re: Is it possible to know where is the "deadlock"
Next
From: "Pat Maddox"
Date:
Subject: Trying to tune postgres, how is this config?