On Tue, Dec 4, 2012 at 11:44:20AM -0200, Edson Richter wrote: > 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. You need to test it but I doubt there would be any measurable difference. If it will always be 14, I would use char(14), and perhaps use a CHECK constraint to make sure it is always 14 with spaces. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
