Postgres Pro
Downloads
Home   >   mailing lists

Overhead changing varchar(2000) to text - Mailing list pgsql-general

From Edson Richter
Subject Overhead changing varchar(2000) to text
Date
Msg-id BLU436-SMTP73C6A08E408BFE28D0D281CFE80@phx.gbl
Whole thread Raw
Responses Re: Overhead changing varchar(2000) to text  (Kevin Grittner <kgrittn@gmail.com>)
List pgsql-general
Tree view 
Hi!

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?

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

Thanks,

--
Atenciosamente,

Edson Carlos Ericksson Richter

pgsql-general by date:

Previous
From: Christopher Molnar
Date:
Subject: Re: Regexp_replace question / help needed
Next
From: Kevin Grittner
Date:
Subject: Re: Overhead changing varchar(2000) to text