Date: Mon, 24 Jun 2013 10:13:50 +0530
From: Abhijit Menon-Sen <ams@2ndQuadrant.com>
To: Simon Riggs <simon@2ndQuadrant.com>
Cc: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>,
 Tom Lane <tgl@sss.pgh.pa.us>, Gavin Flower <gavinflower@archidevsys.co.nz>,
 pgsql-hackers@postgresql.org
Subject: Re: [PERFORM] In progress INSERT wrecks plans on table
Message-ID: <20130624044350.GA32322@toroid.org>
References: <5179F5C6.8070702@archidevsys.co.nz>
 <5180E3C8.3010201@catalyst.net.nz> <2121.1367417215@sss.pgh.pa.us>
 <5181B80D.70404@catalyst.net.nz>
 <CA+U5nMKYYZDekhtxz1E1B11dAm9UJoHBQHrB6DiiZDJo3fLd0Q@mail.gmail.com>
 <916bff05a5ab130c76d7835abbaf7762.squirrel@mail.catalyst.net.nz>
 <CA+U5nMJHjQccVSB3SkAHdRn2AfuuO49wA8-ZGB366cddTynjdQ@mail.gmail.com>
 <CA+U5nMKMfZUEimZ9=oF2wJ-WkiGhMw3mQjUFT6PBGofUpmXL8A@mail.gmail.com>
 <51870CB6.6090404@catalyst.net.nz>
 <CA+U5nMJHgHczmWrKzst=PJeP+9BHJAsTgRNXyVZX5Oyys2zn_g@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CA+U5nMJHgHczmWrKzst=PJeP+9BHJAsTgRNXyVZX5Oyys2zn_g@mail.gmail.com>
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

(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.

-- Abhijit


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers