Skip site navigation (1) Skip section navigation (2)

index on different types

From: Enrico Weigelt <weigelt(at)metux(dot)de>
To: postgresql performance list <pgsql-performance(at)postgresql(dot)org>
Subject: index on different types
Date: 2005-04-29 02:35:13
Message-ID: 20050429023512.GB26200@nibiru.borg.metux.de (view raw or flat)
Thread:
Lists: 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(at)metux(dot)de
---------------------------------------------------------------------
  Realtime Forex/Stock Exchange trading powered by postgresSQL :))
                                            http://www.fxignal.net/
---------------------------------------------------------------------

Responses

pgsql-performance by date

Next:From: Michael FuhrDate: 2005-04-29 03:28:34
Subject: Re: index on different types
Previous:From: Marko RistolaDate: 2005-04-28 17:44:37
Subject: Re: [HACKERS] Bad n_distinct estimation; hacks suggested?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group