Re: planner and join type mismatches

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: planner and join type mismatches
Дата
Msg-id 3619.1074092862@sss.pgh.pa.us
обсуждение исходный текст
Ответ на planner and join type mismatches  ("Jim Wilson" <jimw@kelcomaine.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Jack Orenstein
Дата:
Сообщение: Detecting database corruption
Следующее
От: Yannick Warnier
Дата:
Сообщение: Re: How are NULLS stored on disk for PG 7.4?