Re: planner and join type mismatches

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jimw(at)kelcomaine(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: planner and join type mismatches
Date: 2004-01-14 15:07:42
Message-ID: 3619.1074092862@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Jim Wilson" <jimw(at)kelcomaine(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Yannick Warnier 2004-01-14 15:30:26 Re: How are NULLS stored on disk for PG 7.4?
Previous Message Jack Orenstein 2004-01-14 14:56:54 Detecting database corruption