Request a Demo
Home   >   mailing lists

Re: DISTINCT vs. GROUP BY - Mailing list pgsql-hackers

From Jim C. Nasby
Subject Re: DISTINCT vs. GROUP BY
Date
Msg-id [email protected]
Whole thread Raw
In response to Re: DISTINCT vs. GROUP BY  (Bruce Momjian <[email protected]>)
Responses Re: DISTINCT vs. GROUP BY
List pgsql-hackers
Tree view 
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      [email protected]
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: passing parameters to CREATE INDEX
Next
From: Andrew Dunstan
Date:
Subject: Re: passing parameters to CREATE INDEX