Overhead changing varchar(2000) to text

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Overhead changing varchar(2000) to text
Date: 2015-12-09 23:13:57
Message-ID: BLU436-SMTP73C6A08E408BFE28D0D281CFE80@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Grittner 2015-12-09 23:17:21 Re: Overhead changing varchar(2000) to text
Previous Message Christopher Molnar 2015-12-09 23:02:19 Re: Regexp_replace question / help needed