Request a Demo
Home   >   mailing lists

Generic design: char vs varchar primary keys - Mailing list pgsql-sql

From Raj Mathur (राज माथुर)
Subject Generic design: char vs varchar primary keys
Date
Msg-id 201108032040.17628.raju@linux-delhi.org
Whole thread Raw
Responses Re: Generic design: char vs varchar primary keys
List pgsql-sql
Tree view 
Hi,

Can you point me to any pages that explain the difference between using, 
say CHAR(8) vs VARCHAR(8) as the primary key for a table?  Is there any 
impact on the database in terms of:

- Speed of indexed retrieval
- Speed of join from a referencing table
- Storage (I presume VARHAR(8) would have a slight edge, in general)
- Any other issue

Regards,

-- Raj
-- 
Raj Mathur                raju@kandalaya.org      http://kandalaya.org/      GPG: 78D4 FC67 367F 40E2 0DD5  0FEF C968
D0EFCC68 D17F
 
PsyTrance & Chill: http://schizoid.in/   ||   It is the mind that moves

pgsql-sql by date:

Previous
From: Tim Landscheidt
Date:
Subject: Re: Help with regexp-query
Next
From: Josh Kupershmidt
Date:
Subject: Re: Generic design: char vs varchar primary keys