Re: Avoiding surrogate keys

Поиск
Список
Период
Сортировка
Искать
От
Joshua D. Drake
Тема
Re: Avoiding surrogate keys
Дата
Msg-id
1271877261.2857.0.camel@jd-desktop.iso-8859-1.charter.com
Ответ на
Re: Avoiding surrogate keys (Bill Moran)
Список
Дерево обсуждения
Avoiding surrogate keys Thom Brown <thombrown@gmail.com>
Re: Avoiding surrogate keys Bill Moran <wmoran@potentialtech.com>
Re: Avoiding surrogate keys "Joshua D. Drake" <jd@commandprompt.com>
Re: Avoiding surrogate keys "Joshua D. Drake" <jd@commandprompt.com>
Re: Avoiding surrogate keys Bill Moran <wmoran@potentialtech.com>
Re: Avoiding surrogate keys Alvaro Herrera <alvherre@commandprompt.com>
Re: Avoiding surrogate keys Merlin Moncure <mmoncure@gmail.com>
Re: Avoiding surrogate keys Martin Gainty <mgainty@hotmail.com>
Re: Avoiding surrogate keys "Mark Watson" <mark.watson@jurisconcept.ca>
Re: Avoiding surrogate keys John R Pierce <pierce@hogranch.com>
Re: Avoiding surrogate keys Merlin Moncure <mmoncure@gmail.com>
Re: Avoiding surrogate keys Merlin Moncure <mmoncure@gmail.com>
Re: Avoiding surrogate keys Grzegorz Jaśkiewicz <gryzman@gmail.com>
Re: Avoiding surrogate keys Richard Broersma <richard.broersma@gmail.com>
Re: Avoiding surrogate keys Grzegorz Jaśkiewicz <gryzman@gmail.com>
Re: Avoiding surrogate keys Philippe Lang <philippe.lang@attiksystem.ch>
Re: Avoiding surrogate keys Lew <noone@lwsc.ehost-services.com>
Re: Avoiding surrogate keys Merlin Moncure <mmoncure@gmail.com>
Re: Avoiding surrogate keys Rich Shepard <rshepard@appl-ecosys.com>
Re: Avoiding surrogate keys Merlin Moncure <mmoncure@gmail.com>
Re: Avoiding surrogate keys "Joshua D. Drake" <jd@commandprompt.com>
Re: Avoiding surrogate keys "Joshua D. Drake" <jd@commandprompt.com>
Re: Avoiding surrogate keys Thom Brown <thombrown@gmail.com> 
On Wed, 2010-04-21 at 15:07 -0400, Bill Moran wrote:
> I'd use an ENUM for the status, as that's not liable to change.
> 
> The only problem I see with avoiding the surrogate key for the country
> is that the table might require more disk space if a lot of the country
> names end up being very long.
> 

Yeah but that isn't generally a problem now and the gain he gets from
the lack of join performance is more than worth it.

Joshua D. Drake


-- 
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
В списке pgsql-general по дате отправления
Предыдущее
От: Devrim GÜNDÜZ
Дата:
Следующее
От: Joshua D. Drake
Дата:
Сообщение: Re: Avoiding surrogate keys
FAQ