Re: Datatypes and performance - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: Datatypes and performance
Date
Msg-id 200307042049.49651.shridhar_daithankar@nospam.persistent.co.in
Whole thread Raw
In response to Datatypes and performance  ("Jay O'Connor" <joconnor@cybermesa.com>)
List pgsql-general
On Friday 04 July 2003 21:40, Jay O'Connor wrote:
> 2.varchar and int
> I was using a varchar as one field that's part of an index.  Looking at the
> data, I realized I could just use an int instead.  My assumption would be
> that an int would be faster to serach for thena  varchar, so I converted
> the field to int.  Is this a valid assumption?

Certainly yes.

 Shridhar


pgsql-general by date:

Previous
From: "Jay O'Connor"
Date:
Subject: Datatypes and performance
Next
From: Alvaro Herrera
Date:
Subject: Re: Datatypes and performance