PFC writes:
>- If you process up to some percentage of your RAM worth of data, hashing
> 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?