2011/4/14 Euler Taveira de Oliveira <[email protected]> > Em 14-04-2011 11:04, Marcelo Silva (IG) escreveu: > > Campos Text são sempre mais pesados > > O ideal no seu caso é: character varying mesmo > > > Por quê? Vide código. > > Olá Pessoal, boa tarde,
Aqui segue uma url[1] que pode trazer alguma luz a esse assunto: http://www.postgresql.org/docs/9.0/interactive/datatype-character.html *Tip: * There is no performance difference among these three types, apart from increased storage space when using the blank-padded type, and a few extra CPU cycles to check the length when storing into a length-constrained column. While character(*n*) has performance advantages in some other database systems, there is no such advantage in PostgreSQL; in fact character(*n*) is usually the slowest of the three because of its additional storage costs. In most situations text or character varying should be used instead. > > -- > Euler Taveira de Oliveira > http://www.timbira.com/ > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > -- Vinícius Abrahão Bazana Schmidt Desenvolvimento Dextra Sistemas www.dextra.com.br +55 19 3256-6722 Ramal 246 Este email é confidencial. Mais informações em: This message is confidential. More information at: www.dextra.com.br/confidencial.htm
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
