Re: [PERFORM] In progress INSERT wrecks plans on table

From: Abhijit Menon-Sen <ams(at)2ndQuadrant(dot)com>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Gavin Flower <gavinflower(at)archidevsys(dot)co(dot)nz>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PERFORM] In progress INSERT wrecks plans on table
Date: 2013-06-24 04:43:50
Message-ID: 20130624044350.GA32322@toroid.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

(Cc: to pgsql-performance dropped, pgsql-hackers added.)

At 2013-05-06 09:14:01 +0100, simon(at)2ndQuadrant(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2013-06-24 06:01:06 Re: Reduce maximum error in tuples estimation after vacuum.
Previous Message Josh Berkus 2013-06-24 04:41:13 [9.4 CF 1] The Commitfest Slacker List

Browse pgsql-performance by date

  From Date Subject
Next Message Emrah Mehmedov 2013-06-24 09:55:04 Re: PHP Postgres query slower then PgAdmin
Previous Message Marcin Mańk 2013-06-23 19:57:53 Re: PHP Postgres query slower then PgAdmin