Message-ID: <4E5DC29C.1000700@catalyst.net.nz>
Date: Wed, 31 Aug 2011 17:11:56 +1200
From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.2.20) Gecko/20110805 Lightning/1.0b2 Thunderbird/3.1.12
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: 8.4 optimization regression?
References: <4E5331FF.3000900@catalyst.net.nz>
	<15708.1314155740@sss.pgh.pa.us>	<4E548A7D.6090003@catalyst.net.nz>
	<4E5C14FF.8060909@catalyst.net.nz>
	<CAJY59_jWx4B8LidOoVHj14GiEkO8HJPNp3bCRvqTCJ-z5Z6ubA@mail.gmail.com>
In-Reply-To: 
 <CAJY59_jWx4B8LidOoVHj14GiEkO8HJPNp3bCRvqTCJ-z5Z6ubA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

On 30/08/11 21:43, Grzegorz Jaśkiewicz wrote:
> 2011/8/29 Mark Kirkwood<mark.kirkwood@catalyst.net.nz>:
>
>> I note from the commit message that the fix test case was from Grzegorz
>> Jaskiewicz (antijoin against a small subset of a relation).  I was not able
>> to find this in the archives - Grzegorz do you recall the actual test case?
>> I thought it might be useful for me to spend some time studying both cases
>> and seeing if I can come up with any tweaks that would let both your and my
>> queries work well!
> Sorry, I don't remember that particular example. If I complained about
> it, it would  have been on this list or the general list.
> I'll have a look by date.
>

Thanks - however I think I have managed to make up a good test case that 
shows the particular commit working. More on that to come!

Cheers

Mark