Home > mailing lists

Joins and field types - Mailing list pgsql-general

From	Zak McGregor
Subject	Joins and field types
Date	January 12, 2001 07:36:49
Msg-id	200101120935.LAA01114@zak.home.dom Whole thread Raw
List	pgsql-general

Tree view

Hi all

What sort of performance penalty on joins using varchar(n) vs. int fields can I expect if both tables are fairly small
(ieunlikely to have more than 20000 rows each)? 

Is there a good reference or two on these sorts of questions?

thanks a lot

Ciao

Zak McGregor

pgsql-general by date:

From: "Anthony E . Greene"
Date: 12 January 2001, 07:20:42
Subject: Re: PostgreSQL Client Program

From: Rajit Singh
Date: 12 January 2001, 08:36:24
Subject: timestamp update field across multiple tables

Joins and field types - Mailing list pgsql-general

Previous

Next