Re: In progress INSERT wrecks plans on table

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: In progress INSERT wrecks plans on table
Date: 2013-05-02 00:49:17
Message-ID: 5181B80D.70404@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

On 02/05/13 02:06, Tom Lane wrote:
> Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz> writes:
>> I am concerned that the deafening lack of any replies to my original
>> message is a result of folk glancing at your original quick reply and
>> thinking... incomplete problem spec...ignore... when that is not that
>> case - yes I should have muttered "9.2" in the original email, but we
>> have covered that now.
> No, I think it's more that we're trying to get to beta, and so anything
> that looks like new development is getting shuffled to folks' "to
> look at later" queues. The proposed patch is IMO a complete nonstarter
> anyway; but I'm not sure what a less bogus solution would look like.
>

Yeah, I did think that beta might be consuming everyone's attention (of
course immediately *after* sending the email)!

And yes, the patch was merely to illustrate the problem rather than any
serious attempt at a solution.

Regards

Mark

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Craig Ringer 2013-05-02 02:00:22 Re: Proposal to add --single-row to psql
Previous Message Greg Stark 2013-05-02 00:49:03 Re: Documentation epub format

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2013-05-02 01:51:16 Re: 100x slowdown for nearly identical tables
Previous Message Craig James 2013-05-02 00:45:11 Re: 100x slowdown for nearly identical tables