| 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
| 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 |