Re: [HACKERS] How to read query plan - Mailing list pgsql-performance

From Tom Lane
Subject Re: [HACKERS] How to read query plan
Date
Msg-id 13476.1110812665@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] How to read query plan  (Miroslav Šulc <miroslav.sulc@startnet.cz>)
List pgsql-performance
=?windows-1250?Q?Miroslav_=8Aulc?= <miroslav.sulc@startnet.cz> writes:
> Tom Lane wrote:
>> Actually, we already had a pending patch (from Atsushi Ogawa) that
>> eliminates that particular O(N^2) behavior in another way.  After
>> applying it, I get about a factor-of-4 reduction in the runtime for
>> Miroslav's example.
>>
> Is there a chance we will see this patch in the 8.0.2 release?

No.  We are not in the habit of making non-bug-fix changes in stable
branches.  Ogawa's patch is in CVS for 8.1.

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to read query plan
Next
From: Harald Fuchs
Date:
Subject: Re: How to read query plan