Re: Group by more efficient than distinct?

PFC writes:

>- If you process up to some percentage of your RAM worth of data, ha****ng
 
> is going to be a lot faster

Thanks for the excellent breakdown and explanation. I will try and get
sizes 
of the tables in question and how much memory the machines have. 
 
> 	- If you need DISTINCT ON, well, you're stuck with the Sort
> 	- So, for the time being, you can replace DISTINCT with GROUP BY...

Have seen a few of those already on some code (new job..) so for those it
is 
a matter of having a good disk subsystem?

-- 
Sent via pgsql-performance mailing list (pgsql-performance@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance