String versus integer joins?

From: Veronika Megler <vmegler(at)cecs(dot)pdx(dot)edu>
To: pdxpug(at)postgresql(dot)org
Subject: String versus integer joins?
Date: 2012-10-23 16:40:12
Message-ID: 5086C86C.7020008@cecs.pdx.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pdxpug

Hello all,

I've heard persistent rumors that joining two table based on an integer
id "must be" or "is" faster than joining on a string id.

While I'd believe the "must be", does anyone have any pointers to (or
evidence of) how much faster?

I.e.; if the difference is 10 times, then it's worth us
rewriting/testing/upgrading an application. If it's 10%, then it's not.

Thanks in advance,
Veronika Megler

Responses

Browse pdxpug by date

  From Date Subject
Next Message Joshua D. Drake 2012-10-23 17:39:43 Re: String versus integer joins?
Previous Message Mark Wong 2012-10-16 22:21:51 Re: Upcoming meetings