Re: reducing the overhead of frequent table locks - now, with WIP patch

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Joshua Berkus <josh(at)agliodbs(dot)com>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Subject: Re: reducing the overhead of frequent table locks - now, with WIP patch
Date: 2011-06-07 20:11:46
Message-ID: BANLkTimPbSwUCh2PXb8yCzafOH5jQdp6dQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jun 7, 2011 at 9:00 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Simon Riggs <simon(at)2ndQuadrant(dot)com> writes:
>> Moving on from that, I have proposed other solutions. Koichi, Jignesh
>> and and then Robert have shown measurements of the huge contention in
>> this area of our software. Robert's patch addresses the problems, as
>> do Koichi's and my latest patch.  I would like to see us do
>> *something* about these problems for 9.1. Not all of them are risky or
>> time consuming.
>
> In the first place, all of these issues predate 9.1 by years.  They are
> not regressions or new bugs, and they have not suddenly gotten more
> urgent.  In the second place, I haven't seen any proposals in the area
> that appear low risk.  I seriously doubt that I would consider *any*
> meaningful change in the locking area to be low risk.

That's a shame. We'll fix it in 9.2 then.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-06-07 20:23:01 Re: contrib/citext versus collations
Previous Message Robert Haas 2011-06-07 20:03:26 Re: reducing the overhead of frequent table locks - now, with WIP patch