A simple question about text fields - Mailing list pgsql-general

From Martin Mueller
Subject A simple question about text fields
Date
Msg-id A213AB92-F8BA-4585-98E5-D709FB3BD36B@northwestern.edu
Whole thread Raw
Responses Re: A simple question about text fields  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Are there performance issues with the choice of 'text' vs. varchar and some character limit?  For instance, if I have a
tablewith ten million records and text fields that may range in length from 15 to 150, can I expect a measurable
improvementin response time for using varchar(150) or will text    do just or nearly as well. 
 

If the latter is the case, using text across the board is a simpler choice  
    


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Establishing a local connection to PostgreSQL 9.6 takes seconds
Next
From: Tom Lane
Date:
Subject: Re: A simple question about text fields