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

From: Abhijit Menon-Sen <ams(at)2ndQuadrant(dot)com>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, 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-07-13 09:11:57
Message-ID: 20130713091157.GB1011@toroid.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

At 2013-07-13 14:19:23 +0530, ams(at)2ndQuadrant(dot)com wrote:
>
> The timings above are with both xid_in_snapshot_cache.v1.patch and
> cache_TransactionIdInProgress.v2.patch applied

For anyone who wants to try to reproduce the results, here's the patch I
used, which is both patches above plus some typo fixes in comments.

-- Abhijit

Attachment Content-Type Size
inprogress.diff text/x-diff 7.1 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dimitri Fontaine 2013-07-13 10:10:13 Re: Review: extension template
Previous Message Abhijit Menon-Sen 2013-07-13 08:49:23 Re: [PERFORM] In progress INSERT wrecks plans on table

Browse pgsql-performance by date

  From Date Subject
Next Message Ants Aasma 2013-07-13 13:41:38 Re: In progress INSERT wrecks plans on table
Previous Message Abhijit Menon-Sen 2013-07-13 08:49:23 Re: [PERFORM] In progress INSERT wrecks plans on table