index on different types
От | Enrico Weigelt |
---|---|
Тема | index on different types |
Дата | |
Msg-id | 20050429023512.GB26200@nibiru.borg.metux.de обсуждение исходный текст |
Ответы |
Re: index on different types
|
Список | 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 по дате отправления: