Re: Size or efficiency differences "varchar(128) vs. varchar(32)"

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: emilu(at)encs(dot)concordia(dot)ca
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Size or efficiency differences "varchar(128) vs. varchar(32)"
Date: 2008-07-21 16:17:04
Message-ID: dcc563d10807210917w5382e41an8355b0810a958213@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, Jul 21, 2008 at 8:06 AM, Emi Lu <emilu(at)encs(dot)concordia(dot)ca> wrote:
> Good morning,
>
> I'd like to create a varchar length column.
>
> May I know does varchar(128) and varchar(32) will cause any size or
> efficiency differences?

If you store the same thing in each, no. If you store 128 char text
in the varchar(128) it will of course be bigger than a 32 char text in
the varchar(32) field.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Emi Lu 2008-07-21 16:59:02 Re: Size or efficiency differences "varchar(128) vs. varchar(32)"
Previous Message Alvaro Herrera 2008-07-21 15:40:49 Re: Size or efficiency differences "varchar(128) vs. varchar(32)"