Re: Corner case for add_path_precheck - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Corner case for add_path_precheck
Date
Msg-id 14739.1423694016@sss.pgh.pa.us
Whole thread Raw
In response to Re: Corner case for add_path_precheck  (Antonin Houska <ah@cybertec.at>)
List pgsql-hackers
Antonin Houska <ah@cybertec.at> writes:
> Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Antonin Houska <ah@cybertec.at> writes:
>>> The special case is that the path passed to add_path_precheck() has costs
>>> *equal to* those of the old_path. If pathkeys, outer rells and costs are the
>>> same, as summarized in the comment above, I expect add_path_precheck() to
>>> return false. Do I misread anything?

>> It does, so I don't see your point?

> Just that pre-check is - in this special (and very rare?) case - more
> stringent than the proper check would be.

It's assuming that a nonzero amount of cost will be added on before the
real check happens.  Even if none was added, discarding the new path is
the way we'd break the tie that would result, so I still don't see your
point.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Antonin Houska
Date:
Subject: Re: Corner case for add_path_precheck
Next
From: Anastasia Lubennikova
Date:
Subject: Index-only scans for GiST.