Re: The Future of Aggregation

David Rowley wrote:
> On 10 June 2015 at 03:25, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> wrote:
>
> > Kevin Grittner wrote:
> > > Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> wrote:
> >
> > > > Uh, this also requires serialization and deserialization of non-
> > > > finalized transition state, no?
> > >
> > > For that sort of optimization to incremental maintenance of
> > > materialized views (when we get there), yes. That will be one of
> > > many issues to sort out. Any reason you're focusing on that now?
> > > Do you think we need to settle on a format for that to proceed with
> > > the work David is discussing?
> >
> > No, it's just that it wasn't on David's list.
> >
> That's this part, right?
>
> I wrote:
> "which I believe will need to be modified to implement complex database
> types to backup our internal aggregate state types so that these types be
> properly passed between executor nodes, between worker processes and
> perhaps foreign data wrappers (maybe just postgres_fdw I've not looked into
> this yet)"

Hmm, sort of, I guess. If I understand Kevin correctly, he says these
would be stored on disk alongside matview tuples. Anyway, it's probably
not the hardest issue to solve ...

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services