Re: Window Functions: buffering strategy

From: "Hitoshi Harada" <umi(dot)tanuki(at)gmail(dot)com>
To: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
Cc: "Pg Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Window Functions: buffering strategy
Date: 2008-10-20 14:24:11
Message-ID: e08cc0400810200724x75b02bbfp4800115f0bc6b00e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

2008/10/20 Simon Riggs <simon(at)2ndquadrant(dot)com>:
>
> On Mon, 2008-10-20 at 10:32 +0900, Hitoshi Harada wrote:
>
>> So I propose three Window node buffering strategies,
>> row/frame/partition buffering so as to avoid unnecessary row
>> buffering.
>
> Sounds good from here. Can I suggest you release the code in phases?
>
> It would be better if we got just one of those done (row?), than to
> attempt all 3 and end up with none because of emerging details.

Thank you for your feedback.
Ok, actually the first will be partition buffering, because it covers
all of the functions' requirement. The row buffering is kind of
optimization in the special case.

Regards,

--
Hitoshi Harada

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2008-10-20 14:26:28 pgsql: SQL 200N -> SQL:2003
Previous Message Teodor Sigaev 2008-10-20 14:24:09 Re: Index use during Hot Standby