Re: Datatypes and performance

From: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Datatypes and performance
Date: 2003-07-04 15:19:49
Message-ID: 200307042049.49651.shridhar_daithankar@nospam.persistent.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2003-07-04 15:26:20 Re: PostgreSQL vs. MySQL
Previous Message Shridhar Daithankar 2003-07-04 15:18:39 Re: PostgreSQL vs. MySQL