In response to Joao Ferreira <[EMAIL PROTECTED]>: > 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/ [EMAIL PROTECTED] Phone: 412-422-3463x4023 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
