Re: Window functions patch v04 for the September commit fest

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Window functions patch v04 for the September commit fest
Date: 2008-09-03 08:17:16
Message-ID: 1220429836.4371.664.camel@ebony.2ndQuadrant
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Wed, 2008-09-03 at 09:51 +0300, Heikki Linnakangas wrote:
> Simon Riggs wrote:
> > On Tue, 2008-09-02 at 15:51 +0300, Heikki Linnakangas wrote:
> >
> >> The needs of access to the rows are so different that it seems best to
> >> me to delegate the buffering to the window function.
> >
> > That seems sensible in some ways, not others.
>
> In the API I proposed later in that mail, the buffering is actually done
> by the executor node, not by the window function. Instead, the window
> function can request abitrary rows of the frame from the executor, and
> can signal that some rows are no longer required, allowing them to be
> discarded.

I'm happy with that.

--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2008-09-03 08:20:06 Re: [PATCH] Cleanup of GUC units code
Previous Message Heikki Linnakangas 2008-09-03 07:25:16 Re: Window functions patch v04 for the September commit fest