Generic design: char vs varchar primary keys

Поиск
Список
Период
Сортировка
Искать
От
Raj Mathur (राज माथुर)
Тема
Generic design: char vs varchar primary keys
Дата
Msg-id
201108032040.17628.raju@linux-delhi.org
Список
Дерево обсуждения
Re: Generic design: char vs varchar primary keys Jasen Betts <jasen@xnet.co.nz>
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 D0EF CC68 D17F
PsyTrance & Chill: http://schizoid.in/   ||   It is the mind that moves

В списке pgsql-sql по дате отправления
От: Tim Landscheidt
Дата:
Сообщение: Re: Help with regexp-query
От: Josh Kupershmidt
Дата:
FAQ