Re: text fields and performance for ETL

All of my ETL simply reads in the entire contents of a text field.  There is no chunking.  The documentation assumes that the sizes involved here are reasonable for such behavior.  If you have a situation where you've chosen to use varchar(n) and can defend that choice more power to you.  Those special circumstances are not of particular interest here.  For the vast majority of users they use varchar(n) because they (or more likely their teachers) come from systems where it is required.  The goal in our docs is to point out that using an arbitrary length specification is not required in PostgreSQL.

David J.