Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 320236336BF
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu,  7 Jan 2010 00:22:00 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 21930-03
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu,  7 Jan 2010 04:21:49 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-bw0-f213.google.com (mail-bw0-f213.google.com
	[209.85.218.213])
	by mail.postgresql.org (Postfix) with ESMTP id 4CCD26330AC
	for <pgsql-performance@postgresql.org>;
	Thu,  7 Jan 2010 00:21:49 -0400 (AST)
Received: by bwz5 with SMTP id 5so11435093bwz.3
	for <pgsql-performance@postgresql.org>;
	Wed, 06 Jan 2010 20:21:47 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:date:message-id:subject
	:from:to:content-type;
	bh=xb3MZlFOHL4t5oISKSL9fx6xorN/qZwQnhpvc1JBGoM=;
	b=PMHK2cLhK9GLCViOqpKN1h5vY6+qR6ASnmhntxUH6voeENxZdhMrV7HndUzLfvNYXx
	lamUev68v4iEwncdPXVzh3dgpXIYyAelQR8fUzrI5yjDQc134GxpvEqJ2iLX4KqeBugE
	Wl5Ko+2UyuCXgFlC54xUxtjczdp25nxM4imfM=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=FzXn4OFrRW7UIyaNOk8UwEvHJnzOCZNte2Apfbf38MSHVDX9c19wraGIHM8WVoCxpW
	yTIFDCC1VffNqtvgP1uHiWUinvhDLxXGMeTYSyiPINXSHOzJz874hojf0cwdS4CisoFN
	1jMUz4RI4IdIfl3z1vQ9X82gSzrKqQWudG4i0=
MIME-Version: 1.0
Received: by 10.204.154.207 with SMTP id p15mr919952bkw.202.1262838107635;
	Wed, 06 Jan 2010 20:21:47 -0800 (PST)
Date: Wed, 6 Jan 2010 23:21:47 -0500
Message-ID: <a222cb861001062021l3f29bdc6kb19a3970089b40ae@mail.gmail.com>
Subject: Joining on text field VS int
From: Radhika S <rs88820@gmail.com>
To: pgsql-performance@postgresql.org
Content-Type: multipart/alternative; boundary=001517479572d08170047c8b6811
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=2.449 tagged_above=-10 required=5
	tests=BAYES_20=-0.74, FH_DATE_PAST_20XX=3.188, HTML_MESSAGE=0.001
X-Spam-Level: **
X-Archive-Number: 201001/72
X-Sequence-Number: 36952

--001517479572d08170047c8b6811
Content-Type: text/plain; charset=ISO-8859-1

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 .

--001517479572d08170047c8b6811
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<span class=3D"Apple-style-span" style=3D"border-collapse: collapse; ">Hi,<=
br>I am going to test this out but would be good to know anyways. A large<b=
r>table is joined to a tiny table (8 rows) on a text field. Should I be<br>=
joining on an int field eg: recid intead of name? Is the performance<br>
affected in either case?<br>Thanks .<br></span>

--001517479572d08170047c8b6811--