On 17/1/26 22:10, Tom Lane wrote:
> Andrei Lepikhov <lepihov@gmail.com> writes:
>> Hmm, where is the evidence that your query uses theindex? Maybe the
>> generic plan accidentally forces SeqScan?
>
> Oh ... you're on to something. I think we all assumed that this was
> an intermittent problem, but if it happens every time, I bet it's a
> datatype mismatch issue.
Yes, index mismatches due to type differences are frequently a pain for
me in the world of auto-generated queries. Why not spend a few
additional cycles to check whether a potential cast is possible?
I didn't track what happened in this example, but it would be beneficial
to let an extension implement such functionality. The prosupport
machinery attached to an index looks like a promising approach.
--
regards, Andrei Lepikhov,
pgEdge
