Re: SIREAD lock versus ACCESS EXCLUSIVE lock

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Dan Ports" <drkp(at)csail(dot)mit(dot)edu>
Cc: "Heikki Linnakangas" <heikki(dot)linnakangas(at)enterprisedb(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: SIREAD lock versus ACCESS EXCLUSIVE lock
Date: 2011-04-27 22:25:34
Message-ID: 4DB8518E020000250003CF94@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Dan Ports <drkp(at)csail(dot)mit(dot)edu> wrote:
> On Wed, Apr 27, 2011 at 04:09:38PM -0500, Kevin Grittner wrote:
>> Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> wrote:
>>> Hmm, could we upgrade all predicate locks to relation-level
>>> predicate locks instead?
>>
>> Tied to what backend?

> I think Heikki was suggesting to upgrade to relation-level SIREAD
> locks.

Oh, yeah. That *is* what he said, isn't it. That's a simpler
solution which works just fine. Please forget my over-excited
flights of fancy on the topic -- I was so focused on what I thought
was the solution I misread Heikki's much better idea as some
variation on my theme. :-(

-Kevin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message nadosilok 2011-04-27 22:26:22 Re: [ANNOUNCE] PostgreSQL Core Team
Previous Message Noah Misch 2011-04-27 22:14:31 Re: pg_upgrade automatic testing