Re: Overhead changing varchar(2000) to text

On Wed, Dec 9, 2015 at 5:13 PM, Edson Richter <edsonrichter@hotmail.com> wrote:

> I do have several tables that uses varchar(2000) as store for remarks.
> Lately, one customer need to store more than 2000 characteres, and I'm
> considering changing from varchar(2000) to text.
>
> What is the overhead?

None -- they are stored in exactly the same format; the only
difference is whether the length is limited.

> Is there any place where I can learn about storage impacto for each data
> type?

http://www.postgresql.org/docs/current/interactive/datatype-character.html

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company