Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group