Thread: Re: planner and join type mismatches

Re: planner and join type mismatches

From
"Jim Wilson"
Date:
Tom Lane <tgl@sss.pgh.pa.us> said:

> "Jim Wilson" <jimw@kelcomaine.com> writes:
> > Re: tip 9 :-).  In 7.3.5 is it possible that the planner is finding a type
> > mismatch when there isn't one, resulting in a seq scan being selected?
>
> When you gave no details, how is anyone to know?  For questions like
> this, you need to post the table definitions, the exact query, and the
> results of EXPLAIN ANALYZE on that query.  BTW, pgsql-performance is a
> more appropriate list than -general for such questions.
>
>             regards, tom lane

My apologies.  I think you did answer my question though, that there isn't a
well known problem as described (in it's general scope).  As soon as I get a
chance I will put together a test case and post the issue to psql-performance.

Best,

Jim Wilson