Re: DISTINCT vs. GROUP BY

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: DISTINCT vs. GROUP BY
Дата
Msg-id 20050920194041.GR7630@pervasive.com
обсуждение исходный текст
Ответ на Re: DISTINCT vs. GROUP BY  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: DISTINCT vs. GROUP BY  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Дерево обсуждения 
On Mon, Sep 19, 2005 at 10:16:36PM -0400, Bruce Momjian wrote:
>  
> Added to TODO:
> 
>     * Allow DISTINCT to use hashing like GROUP BY

3 lines above we have...
Consider using hash buckets to do DISTINCT, rather than sorting
This would be beneficial when there are few distinct values. 

Can you add
http://archives.postgresql.org/pgsql-hackers/2005-09/msg00810.php? All I
could find on the other TODO was
http://archives.postgresql.org/pgsql-committers/2004-09/msg00028.php,
which doesn't help much...
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

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

Предыдущее
От: Oleg Bartunov
Дата:
Сообщение: passing parameters to CREATE INDEX
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: passing parameters to CREATE INDEX