Horton

Re: planner and join type mismatches

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: jimw@kelcomaine.com
Cc: pgsql-general@postgresql.org
Date: 2004-01-14T15:07:42Z
Lists: pgsql-general 
"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