From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: pgsql-performance@postgresql.org
Subject: Re: 8.4 optimization regression?
Date: Wed, 31 Aug 2011 17:11:56 +1200
Message-ID: <4E5DC29C.1000700@catalyst.net.nz> (raw)
In-Reply-To: <CAJY59_jWx4B8LidOoVHj14GiEkO8HJPNp3bCRvqTCJ-z5Z6ubA@mail.gmail.com>
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mark.kirkwood@catalyst.net.nz
Subject: Re: 8.4 optimization regression?
In-Reply-To: <4E5DC29C.1000700@catalyst.net.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox