Re: [PERFORM] In progress INSERT wrecks plans on table - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: [PERFORM] In progress INSERT wrecks plans on table
Date
Msg-id 51DAF2C8.6010705@agliodbs.com
Whole thread Raw
In response to Re: [PERFORM] In progress INSERT wrecks plans on table  (Abhijit Menon-Sen <ams@2ndQuadrant.com>)
List pgsql-hackers
On 06/23/2013 09:43 PM, Abhijit Menon-Sen wrote:
> (Cc: to pgsql-performance dropped, pgsql-hackers added.)
> 
> At 2013-05-06 09:14:01 +0100, simon@2ndQuadrant.com wrote:
>>
>> New version of patch attached which fixes a few bugs.
> 
> I read the patch, but only skimmed the earlier discussion about it. In
> isolation, I can say that the patch applies cleanly and looks sensible
> for what it does (i.e., cache pgprocno to speed up repeated calls to
> TransactionIdIsInProgress(somexid)).
> 
> In that sense, it's ready for committer, but I don't know if there's a
> better/more complete/etc. way to address the original problem.

Has this patch had performance testing?  Because of the list crossover I
don't have any information on that.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: [9.4 CF 1] Week 3 report
Next
From: Cédric Villemain
Date:
Subject: Re: Millisecond-precision connect_timeout for libpq