Home > mailing lists

Joining on text field VS int - Mailing list pgsql-performance

From	Radhika S
Subject	Joining on text field VS int
Date	January 7, 2010 03:22:00
Msg-id	a222cb861001062021l3f29bdc6kb19a3970089b40ae@mail.gmail.com Whole thread Raw
Responses	Re: Joining on text field VS int (Nikolas Everett <nik9000@gmail.com>)
List	pgsql-performance

Tree view

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 .

pgsql-performance by date:

From: Nikolas Everett
Date: 07 January 2010, 03:01:16
Subject: Re: noob inheritance question

From: Jesper Krogh
Date: 07 January 2010, 05:11:29
Subject: Re: Digesting explain analyze

Joining on text field VS int - Mailing list pgsql-performance

Previous

Next