Re: Does max size of varchar influence index size

Поиск
Список
Период
Сортировка
От Franck Routier
Тема Re: Does max size of varchar influence index size
Дата
Msg-id 1214924736.668.22.camel@franck-laptop
обсуждение исходный текст
Ответ на Re: Does max size of varchar influence index size  (Mark Roberts <mailing_lists@pandapocket.com>)
Ответы Re: Does max size of varchar influence index size  (Richard Huxton <dev@archonet.com>)
Список pgsql-performance
Le lundi 30 juin 2008 à 13:24 -0700, Mark Roberts a écrit :

Hi Mark,

> Is there any particular reason that you're not using a surrogate key?

Well, human readability is the main reason, no standard way to handle
sequences between databases vendors being the second... (and also
problems when copying data between different instances of the database).

So surrogate keys could be a way, and I am considering this, but I'd
rather avoid it :)

Franck





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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Inact_dirty is increasing continuously and causing the system to hang.
Следующее
От: Peter Schuller
Дата:
Сообщение: Re: VACUUM ANALYZE blocking both reads and writes to a table