2008/6/3 David Fetter <david(at)fetter(dot)org>:
> On Tue, Jun 03, 2008 at 03:36:44PM +0200, Pavel Stehule wrote:
>> Hello David
>> Consider using hash buckets to do DISTINCT, rather than sorting This
>> would be beneficial when there are few distinct values. This is
>> already used by GROUP BY.
> It's nice to see that this is kinda on the TODO, but it doesn't
> address the question I asked, which is, "how would I get the planner
> to rewrite DISTINCTs as the equivalent GROUP BYs?" :)
you can't to do it :(
> Any hints?
> David Fetter <david(at)fetter(dot)org> http://fetter.org/
> Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
> Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
> Remember to vote!
> Consider donating to Postgres: http://www.postgresql.org/about/donate
In response to
pgsql-hackers by date
|Next:||From: David E. Wheeler||Date: 2008-06-03 16:36:45|
|Subject: Re: Case-Insensitve Text Comparison|
|Previous:||From: David Fetter||Date: 2008-06-03 14:03:06|
|Subject: Re: DISTINCT -> GROUP BY|