Re: Proposal of tunable fix for scalability of 8.4 - Mailing list pgsql-performance

From Tom Lane
Subject Re: Proposal of tunable fix for scalability of 8.4
Date
Msg-id 12292.1236964604@sss.pgh.pa.us
Whole thread Raw
In response to Re: Proposal of tunable fix for scalability of 8.4  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Proposal of tunable fix for scalability of 8.4  (Scott Carey <scott@richrelevance.com>)
Re: Proposal of tunable fix for scalability of 8.4  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: Proposal of tunable fix for scalability of 8.4  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-performance
Robert Haas <robertmhaas@gmail.com> writes:
> I think that changing the locking behavior is attacking the problem at
> the wrong level anyway.

Right.  By the time a patch here could have any effect, you've already
lost the game --- having to deschedule and reschedule a process is a
large cost compared to the typical lock hold time for most LWLocks.  So
it would be better to look at how to avoid blocking in the first place.

            regards, tom lane

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
Next
From: "Jignesh K. Shah"
Date:
Subject: Re: Proposal of tunable fix for scalability of 8.4