"buppcpp" <buppcpp@...> wrote:

>
> That's what I thought, when I use DISTINCT I don't see the memory
> usage go up like it should.

DISTINCT indicates that duplicates should be eliminated. This is performed
as soon as possible, i.e. in the process of sorting, not after that. Hence
this is expected that DISTINCT occupies less sort memory than ORDER BY.


Dmitry