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

From Jim Wilson
Subject Re: planner and join type mismatches
Date
Msg-id twig.1074095178.64519@kelcomaine.com
Whole thread Raw
In response to planner and join type mismatches  ("Jim Wilson" <jimw@kelcomaine.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Mike Nolan
Date:
Subject: Schemas not created on restore
Next
From: Francisco Reyes
Date:
Subject: Rights in 7.4