Primary Key Performance with INTEGER vs. VARCHAR

Поиск
Список
Период
Сортировка
От Siah
Тема Primary Key Performance with INTEGER vs. VARCHAR
Дата
Msg-id 1185022160.688503.236330@n2g2000hse.googlegroups.com
обсуждение исходный текст
Ответы Re: Primary Key Performance with INTEGER vs. VARCHAR  (Jim Nasby <decibel@decibel.org>)
Re: Primary Key Performance with INTEGER vs. VARCHAR  ("Merlin Moncure" <mmoncure@gmail.com>)
Список pgsql-general
Hi,

Designing my application, I was wondering if having my primary keys
(to be indexed) with VARCHAR brings performance down significantly? My
own test didn't show much difference. Thinking about it though, I'd
guess Integer Indexing should be much quicker and efficient.

I'd appreciate all comments in this regard,
Mike


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

Предыдущее
От: "Chris Hoover"
Дата:
Сообщение: Help with date math
Следующее
От: "Mitchell Vincent"
Дата:
Сообщение: PGInstaller Project