Joining on text field VS int

From: Radhika S <rs88820(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Joining on text field VS int
Date: 2010-01-07 04:21:47
Message-ID: a222cb861001062021l3f29bdc6kb19a3970089b40ae@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,
I am going to test this out but would be good to know anyways. A large
table is joined to a tiny table (8 rows) on a text field. Should I be
joining on an int field eg: recid intead of name? Is the performance
affected in either case?
Thanks .

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jesper Krogh 2010-01-07 06:10:28 Re: Digesting explain analyze
Previous Message Nikolas Everett 2010-01-07 04:00:42 Re: noob inheritance question