Re: SELECT DISTINCT Performance Issue

Поиск
Список
Период
Сортировка
От George Essig
Тема Re: SELECT DISTINCT Performance Issue
Дата
Msg-id 6744b385050608075132eeb8a6@mail.gmail.com
обсуждение исходный текст
Ответ на Re: SELECT DISTINCT Performance Issue  (K C Lau <kclau60@netvigator.com>)
Список pgsql-performance
On 6/8/05, K C Lau <kclau60@netvigator.com> wrote:
> Both keys are text fields. Does it make any difference if PlayerID were
> integer?
>

It can make a difference in speed and integrity.  If the column is an
integer, the storage on disk could be smaller for the column and the
related indexes.  If the the column is an integer, it would not be
possible to have a value like 'arbitrary value that looks nothing like
an integer'.

George Essig

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: full outer performance problem
Следующее
От: Allan Wang
Дата:
Сообщение: Performance problems, bad estimates and plan