On Tue, Jun 03, 2008 at 03:36:44PM +0200, Pavel Stehule wrote: > Hello David > > http://www.postgresql.org/docs/faqs.TODO.html > > 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?" :) Any hints? Cheers, David. -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
