Re: char() or varchar() for frequently used column

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: jules(dot)alberts(at)arbodienst-limburg(dot)nl, pgsql-novice(at)postgresql(dot)org
Subject: Re: char() or varchar() for frequently used column
Date: 2002-10-17 16:16:50
Message-ID: web-1790025@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Jules,

> Are there any flaws in this approach? Will I get in trouble when
> using
> indexes. Will performance be hampered severely? (we're not talking
> about huge amounts of transactions)

On postgresql, there is no performance difference between CHAR and
VARCHAR. And a VARCHAR(25) which only has 1 character in each row is
no slower than a VARCHAR(2) that has only one character.

-Josh Berkus

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tan ga 2002-10-17 16:52:05 How to extract hour and minutes from a timestamp
Previous Message Josh Berkus 2002-10-17 16:12:18 Re: information