Re: add_path optimization - Mailing list pgsql-hackers

From Tom Lane
Subject Re: add_path optimization
Date
Msg-id 3917.1233768167@sss.pgh.pa.us
Whole thread Raw
In response to Re: add_path optimization  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: add_path optimization
List pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> Tom Lane <tgl@sss.pgh.pa.us> wrote: 
>> there's some sort of logic bug here someplace.
> Keep in mind that this is running with the patch that started this
> thread.  I didn't try actually running this query on 8.4devel without
> the patch.  Should I kill this query, revert the software to
> pre-patch, and try it again to see, or are you confident that that's
> not the issue?

Hmm.  It would be worth checking whether you get the same plan without
the patch (you should, but let's check).  If it is the same plan then
it's not going to be any faster.  I don't see any value in trying to let
the query run to conclusion either.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: Review: B-Tree emulation for GIN
Next
From: Robert Haas
Date:
Subject: Re: add_path optimization