Which is faster: char(14) or varchar(14)

Поиск
Список
Период
Сортировка
От Edson Richter
Тема Which is faster: char(14) or varchar(14)
Дата
Msg-id BLU0-SMTP416DB00C21E4E2FBC9B939ECF470@phx.gbl
обсуждение исходный текст
Ответы Re: Which is faster: char(14) or varchar(14)
Список pgsql-general
I think I already know the answer (char(14)), but I would like to
confirm: which is faster?

In Brazil, company id has 14 digits (12 identifiers, 2 control digits).
By today, application use varchar(14) for these, but I intend to
optimize insert/update/delete and search, and I'm considering to change
it to char(14).

Will it give ANY gain? I do use equality and like operators for search.


Regards,

Edson


В списке pgsql-general по дате отправления:

Предыдущее
От: Vincent Veyron
Дата:
Сообщение: Re: SETOF come ritorno delle funzioni
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Which is faster: char(14) or varchar(14)