The speed problem of Varchar vs. Char

From: Crystal <support(at)conceptpatterns(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: The speed problem of Varchar vs. Char
Date: 2007-07-08 23:15:04
Message-ID: f6rr5k$1afj$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

Our company need to save contact details into the PostgreSQL database. I
just begin to learn it, so I got many questions. I am not sure which
data type I should choose for website address, varchar or char. The
website address may be very long, and we also don't want to lose the
speed. Thus, the question is: if we have a large contact database, how
much slowdown or speed up will be expected if we choose variable length
rather than fixed length? Thanks forward.

Best Wishes,
Crystal

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martin Gainty 2007-07-08 23:52:33 Re: The speed problem of Varchar vs. Char
Previous Message Alvaro Herrera 2007-07-08 23:12:46 Re: Problem with autovacuum and pg_autovacuum