Re: Datatypes and performance

Поиск
Список
Период
Сортировка
От Shridhar Daithankar
Тема Re: Datatypes and performance
Дата
Msg-id 200307042049.49651.shridhar_daithankar@nospam.persistent.co.in
обсуждение исходный текст
Ответ на Datatypes and performance  ("Jay O'Connor" <joconnor@cybermesa.com>)
Список 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 по дате отправления:

Предыдущее
От: "Jay O'Connor"
Дата:
Сообщение: Datatypes and performance
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Datatypes and performance