In response to Joao Ferreira <jmcferreira@xxxxxxxxxxxxxxxxxx>: > Hello all, > > I have a big database in which much information is stored in TEXT type > columns (I did this initially because I did not want to limit the > maximum size of the string to be stored)... but... > > .. let's say I choose an upper limit (p.ex. 200) for the string sizes > and I start a fresh database with VARCHAR(200). > > What tradeoffs can I expect ? disk usage ? query execution times ? See the "Tip" on this page, it answers your questions: http://www.postgresql.org/docs/8.3/static/datatype-character.html -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ wmoran@xxxxxxxxxxxxxxxxxxxxxxx Phone: 412-422-3463x4023
