Edson Richter <edsonrich...@hotmail.com> writes: > In this specific case, the full length (14) is mandatory... so seems > there is no loss or gain. > Also, I see all varchar(...) created are by default "storage = > EXTENDED" (from "Pg Admin"), while other datatypes (like numeric, > smallint, integer) are "storage = MAIN". > Can I have a gain using fixed length datatype in place of current > varchar (like "numeric (14,0)")? > Or changing to "char(14) check length(doc)=14" and "storage=MAIN"?
Sounds like premature optimization to me. I'd first express what I want as clear as possible, e.g. "CREATE DOMAIN BrazilianCompanyId AS char(14)", and try to spot and fix performance problems when I'm done with all that. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
