Re: The Future of Aggregation - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: The Future of Aggregation
Date
Msg-id 20150610031711.GW133018@postgresql.org
Whole thread Raw
In response to Re: The Future of Aggregation  (David Rowley <david.rowley@2ndquadrant.com>)
List pgsql-hackers
David Rowley wrote:
> On 10 June 2015 at 03:25, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
> 
> > Kevin Grittner wrote:
> > > Alvaro Herrera <alvherre@2ndquadrant.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



pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: The Future of Aggregation
Next
From: "Joshua D. Drake"
Date:
Subject: Re: pg_archivecleanup bug (invalid filename input)