Re: oversight in parallel aggregate - Mailing list pgsql-hackers

From David Rowley
Subject Re: oversight in parallel aggregate
Date
Msg-id CAKJS1f9xfuUsT3AtUd1LGHyGV5FfmuphHNj-7ZMmeMOBGxz0bQ@mail.gmail.com
Whole thread Raw
In response to oversight in parallel aggregate  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: oversight in parallel aggregate  (David Rowley <david.rowley@2ndquadrant.com>)
Re: oversight in parallel aggregate  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 5 April 2016 at 11:59, Robert Haas <robertmhaas@gmail.com> wrote:
> One of my EDB colleagues, while in the process of refactoring some
> unrelated Advanced Server code, discovered that (1) there's no way to
> mark an aggregate as anything other than parallel-unsafe but (2) it
> doesn't matter because has_parallel_hazard ignores Aggrefs anyway.
> These mistakes cancel each other out (sorta) if all of your aggregates
> happen to be parallel-safe, but otherwise not so much.  Barring
> objections, I intend to speedily apply the attached patch to fix this.

Thanks for working on this. I should have noticed this myself...

I had a quick look at this and I manged to make this happen;

david=# create aggregate mysum(int) (sfunc=int4pl, combinefunc=int4pl,
stype=int, parallel);
server closed the connection unexpectedly

I've attached a fix, which makes the code a bit more simple, and also
inline with the other code in DefineAggregate().

I think there was also a couple of missing syntax synopsis in the docs
too. I've added those.

--
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Yet another small patch - reorderbuffer.c:1099
Next
From: Peter Eisentraut
Date:
Subject: Re: [COMMITTERS] pgsql: Add trigonometric functions that work in degrees.