Re: add_path optimization - Mailing list pgsql-hackers

From Tom Lane
Subject Re: add_path optimization
Date
Msg-id 4418.1233770376@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  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> Tom Lane <tgl@sss.pgh.pa.us> wrote: 
>> It would be worth checking whether you get the same plan without
>> the patch (you should, but let's check).
> Same plan.

Yeah, I just managed to reproduce a similar behavior in unpatched HEAD.
Now, since I'm running without any stats, it might be that it's
estimating similar costs for the one-key and two-key merges; but I don't
see why that would happen for you.  Off to do some debugging.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: LIMIT NULL
Next
From: Svenne Krap
Date:
Subject: Re: LIMIT NULL