Re: add_path optimization

"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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