Re: reducing the overhead of frequent table locks - now, with WIP patch - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: reducing the overhead of frequent table locks - now, with WIP patch
Date
Msg-id 4DECA9CA.7050400@enterprisedb.com
Whole thread Raw
In response to Re: reducing the overhead of frequent table locks - now, with WIP patch  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: reducing the overhead of frequent table locks - now, with WIP patch
List pgsql-hackers
On 06.06.2011 12:40, Simon Riggs wrote:
> On Sat, Jun 4, 2011 at 5:55 PM, Tom Lane<tgl@sss.pgh.pa.us>  wrote:
>> Simon Riggs<simon@2ndquadrant.com>  writes:
>>> The approach looks sound to me. It's a fairly isolated patch and we
>>> should be considering this for inclusion in 9.1, not wait another
>>> year.
>>
>> That suggestion is completely insane.  The patch is only WIP and full of
>> bugs, even according to its author.  Even if it were solid, it is way
>> too late to be pushing such stuff into 9.1.  We're trying to ship a
>> release, not find ways to cause it to slip more.
>
> In 8.3, you implemented virtual transactionids days before we produced
> a Release Candidate, against my recommendation.

FWIW, this bottleneck was not introduced by the introduction of virtual 
transaction ids. Before that patch, we just took the lock on the real 
transaction id instead.

> The fact that you disagree with me does not make me insane.

You are not insane, even if your suggestion is.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: reducing the overhead of frequent table locks - now, with WIP patch
Next
From: Heikki Linnakangas
Date:
Subject: Re: WIP: Fast GiST index build