Postgres Pro
Downloads
Home   >   mailing lists

Re: planner and join type mismatches - Mailing list pgsql-general

From Tom Lane
Subject Re: planner and join type mismatches
Date
Msg-id 3619.1074092862@sss.pgh.pa.us
Whole thread Raw
In response to planner and join type mismatches  ("Jim Wilson" <jimw@kelcomaine.com>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: Jack Orenstein
Date:
Subject: Detecting database corruption
Next
From: Yannick Warnier
Date:
Subject: Re: How are NULLS stored on disk for PG 7.4?