Re: lag_until_you_get_something() OVER () window function - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: lag_until_you_get_something() OVER () window function
Date
Msg-id CAHyXU0zwxgmTPditwzjytxY2F+O68GU7oQ8qVcrKcGxMFkoCtg@mail.gmail.com
Whole thread Raw
In response to Re: lag_until_you_get_something() OVER () window function  (Kirk Roybal <kirk@webfinish.com>)
List pgsql-hackers
On Wed, Oct 29, 2014 at 12:04 PM, Kirk Roybal <kirk@webfinish.com> wrote:
> This [custom aggregate gapfill] is a pretty elegant way of getting there.
>
> It also does a better job of respecting the window frame.
>
> I'll use this until this
> https://commitfest.postgresql.org/action/patch_view?id=1096 shows up.

Yes. In fact it turns out you can implement all kinds of things
including gaps in standards support by via the combination of windows
functions + custom aggregates.  Performance is pretty good but not
great.

merlin



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: pg_background (and more parallelism infrastructure patches)
Next
From: Andres Freund
Date:
Subject: Re: Lockless StrategyGetBuffer() clock sweep