Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 09EC8B5DC42 for ; Sat, 17 Sep 2011 14:00:29 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 72705-06 for ; Sat, 17 Sep 2011 17:00:22 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from exprod7og113.obsmtp.com (exprod7og113.obsmtp.com [64.18.2.179]) by mail.postgresql.org (Postfix) with ESMTP id 2C240B5DC33 for ; Sat, 17 Sep 2011 14:00:21 -0300 (ADT) Received: from mail-fx0-f52.google.com ([209.85.161.52]) (using TLSv1) by exprod7ob113.postini.com ([64.18.6.12]) with SMTP ID DSNKTnTSJFqAoWeAvj4sYfJi2R6aDw3t/4of@postini.com; Sat, 17 Sep 2011 10:00:21 PDT Received: by fxe23 with SMTP id 23so3768648fxe.11 for ; Sat, 17 Sep 2011 10:00:18 -0700 (PDT) Received: by 10.223.100.71 with SMTP id x7mr1513077fan.18.1316278818780; Sat, 17 Sep 2011 10:00:18 -0700 (PDT) Received: from [10.0.0.34] (dsl-prvbrasgw1-fe14dc00-239.dhcp.inet.fi. [80.220.20.239]) by mx.google.com with ESMTPS id a1sm15151037fab.4.2011.09.17.10.00.16 (version=TLSv1/SSLv3 cipher=OTHER); Sat, 17 Sep 2011 10:00:17 -0700 (PDT) Message-ID: <4E74D21C.2070503@enterprisedb.com> Date: Sat, 17 Sep 2011 20:00:12 +0300 From: Heikki Linnakangas User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; fi-FI; rv:1.9.2.21) Gecko/20110831 Icedove/3.1.13 MIME-Version: 1.0 To: Alexander Korotkov CC: pgsql-hackers Subject: Re: Double sorting split patch References: <4E72197B.9040602@enterprisedb.com> <4E732DFF.9070900@enterprisedb.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201109/815 X-Sequence-Number: 195004 On 17.09.2011 17:36, Alexander Korotkov wrote: > On Fri, Sep 16, 2011 at 3:07 PM, Heikki Linnakangas< > heikki.linnakangas@enterprisedb.com> wrote: > >> That looks awfully complicated. I don't understand how that works. I wonder >> if two passes would be simpler? >> > I doubt it becomes much simpler, but here it is. Thanks! It does look a lot simpler that way, IMHO. I presume this didn't change the performance characteristics? -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com