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