Which is faster: char(14) or varchar(14) - Mailing list pgsql-general

From Edson Richter
Subject Which is faster: char(14) or varchar(14)
Date
Msg-id BLU0-SMTP416DB00C21E4E2FBC9B939ECF470@phx.gbl
Whole thread Raw
Responses Re: Which is faster: char(14) or varchar(14)
List 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 by date:

Previous
From: Vincent Veyron
Date:
Subject: Re: SETOF come ritorno delle funzioni
Next
From: Bruce Momjian
Date:
Subject: Re: Which is faster: char(14) or varchar(14)