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

From Robert Haas
Subject Re: The Future of Aggregation
Date
Msg-id CA+TgmoZwPzWkaZs+bns-kDuzpAL1WDYMoBUaguFvrokKPHG6NA@mail.gmail.com
Whole thread Raw
In response to Re: The Future of Aggregation  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: The Future of Aggregation  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Tue, Jun 9, 2015 at 11:00 AM, Alvaro Herrera
<alvherre@2ndquadrant.com> wrote:
> Uh, this also requires serialization and deserialization of non-
> finalized transition state, no?

A bunch of this stuff does, but I recently had a Brilliant Insight: we
don't need to add a new method for serializing and deserializing
transition functions.  We can already do that: to serialize an
aggregate transition state, you run it through the typoutput (or
typsend) function and to deserialize it, you run it through the
typinput (or typreceive) function.  The only problem is that we have
some aggregate functions that use an internal type.  Those could,
however, be changed: we could invent new types for each aggregate that
uses a distinctive internal representation, rather than lumping it all
under internal, and then give those types real input and output
functions.  That way, we don't really need to invent anything new
here.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Kouhei Kaigai
Date:
Subject: Re: DBT-3 with SF=20 got failed
Next
From: Robert Haas
Date:
Subject: Re: The purpose of the core team