Re: Generic design: char vs varchar primary keys

Поиск
Список
Период
Сортировка
От Jasen Betts
Тема Re: Generic design: char vs varchar primary keys
Дата
Msg-id j1goi4$m5j$2@reversiblemaps.ath.cx
обсуждение исходный текст
Ответ на Generic design: char vs varchar primary keys  ("Raj Mathur (राज माथुर)" <raju@linux-delhi.org>)
Список pgsql-sql
On 2011-08-04, Raj Mathur (राज माथुर) <raju@linux-delhi.org> wrote:

> Thanks, that's useful for benchmarking the various textual data types.  
> Anything specific about using CHAR vs VARCHAR for primary keys that are 
> going to be referenced from multiple tables that comes to mind?

that page he pointed you to says they are all stored the same.
(excepte char(8) is padded and that may bloat the index a bit)

-- 
⚂⚃ 100% natural



В списке pgsql-sql по дате отправления:

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: Generic design: char vs varchar primary keys
Следующее
От: "ai"
Дата:
Сообщение: Problem with nested left-joins and coalesce