From: | Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | distinct vs group by |
Date: | 2005-01-28 10:35:21 |
Message-ID: | Pine.LNX.4.58.0501280229240.22244@greenie.cheapcomplexdevices.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Should the expressions
select distinct x from t
and
select x from t group by x
have the same effect?
It seems the optimizer sometimes chooses different plans for those
expressions. Could the select distinct have used the slightly
faster hash aggregate?
Thanks.
fli=# explain select distinct zip from sa_zips;
QUERY PLAN
--------------------------------------------------------------------
Unique (cost=3.65..3.98 rows=66 width=8)
-> Sort (cost=3.65..3.82 rows=66 width=8)
Sort Key: zip
-> Seq Scan on sa_zips (cost=0.00..1.66 rows=66 width=8)
(4 rows)
fli=# explain select zip from sa_zips group by zip;
QUERY PLAN
--------------------------------------------------------------
HashAggregate (cost=1.82..1.82 rows=66 width=8)
-> Seq Scan on sa_zips (cost=0.00..1.66 rows=66 width=8)
(2 rows)
From | Date | Subject | |
---|---|---|---|
Next Message | Justus Mugbeh | 2005-01-28 14:27:17 | How to get hold of postgres sql |
Previous Message | John DeSoi | 2005-01-28 04:10:04 | Re: Can't Get Going in psql |