Re: SELECT DISTINCT too slow

From: Miroslav Šulc <miroslav(dot)sulc(at)startnet(dot)cz>
To:
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SELECT DISTINCT too slow
Date: 2006-06-01 15:39:48
Message-ID: 447F0A44.3080500@startnet.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

The GROUP BY is really fast :-)

Thank you.

Miroslav Šulc

Tom Lane napsal(a):
> Try
> SELECT Key FROM MRTPContactValue GROUP BY Key
>
> The "select distinct" code is a bit old and crufty, GROUP BY is usually
> smarter.
>
> regards, tom lane
>

Attachment Content-Type Size
miroslav.sulc.vcf text/x-vcard 349 bytes

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Greg Stark 2006-06-01 15:40:59 Re: Table design question
Previous Message Tom Lane 2006-06-01 15:20:30 Re: SELECT DISTINCT too slow