Re: Sorting. When?

From: Nicolas Barbier <nicolas(dot)barbier(at)gmail(dot)com>
To: "mac_man2008(at)yahoo(dot)it" <mac_man2008(at)yahoo(dot)it>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Sorting. When?
Date: 2011-02-10 23:21:50
Message-ID: AANLkTikg9_iUd+aU8nnmuPrtfx6FgugO4NCfCoQiRcK4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2011/2/10 mac_man2008(at)yahoo(dot)it <mac_man2008(at)yahoo(dot)it>:

> Which operations invoke the sorting algorithms implemented in the sorting
> module (tuplesort.c) ?
> Of course, one of those operations invoking sorting is the ORDER BY clause
> and the DISTINCT too.
>
> Moreover, the Merge Join should be implemented invoking sorting.
>
> Is there any other operation invoking sorting?

AFAIK, all set operators except for UNION ALL. (I am probably missing
a whole boatload of other things.)

Nicolas

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David E. Wheeler 2011-02-10 23:28:31 Careful PL/Perl Release Not Required
Previous Message Alvaro Herrera 2011-02-10 23:06:32 Re: Debian readline/libedit breakage