Re: lag_until_you_get_something() OVER () window function

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: lag_until_you_get_something() OVER () window function
Дата
Msg-id CAHyXU0zwxgmTPditwzjytxY2F+O68GU7oQ8qVcrKcGxMFkoCtg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: lag_until_you_get_something() OVER () window function  (Kirk Roybal <kirk@webfinish.com>)
Список 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 по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: pg_background (and more parallelism infrastructure patches)
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Lockless StrategyGetBuffer() clock sweep