index on different types

Поиск
Список
Период
Сортировка
От Enrico Weigelt
Тема index on different types
Дата
Msg-id 20050429023512.GB26200@nibiru.borg.metux.de
обсуждение исходный текст
Ответы Re: index on different types  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-performance
Hi folks,


there's often some talk about indices cannot be used if datatypes
dont match.

On a larger (and long time growed) application I tend to use OID
for references on new tables while old stuff is using integer.
Is the planner smart enough to see both as compatible datatype
or is manual casting required ?


thx
--
---------------------------------------------------------------------
 Enrico Weigelt    ==   metux IT service
  phone:     +49 36207 519931         www:       http://www.metux.de/
  fax:       +49 36207 519932         email:     contact@metux.de
---------------------------------------------------------------------
  Realtime Forex/Stock Exchange trading powered by postgresSQL :))
                                            http://www.fxignal.net/
---------------------------------------------------------------------

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

Предыдущее
От: Marko Ristola
Дата:
Сообщение: Re: [HACKERS] Bad n_distinct estimation; hacks suggested?
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: [HACKERS] Bad n_distinct estimation; hacks suggested?