Re: [PATCH] Negative Transition Aggregate Functions (WIP)

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: Florian Pflug <fgp(at)phlo(dot)org>, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Kevin Grittner <kgrittn(at)ymail(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, Greg Stark <stark(at)mit(dot)edu>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCH] Negative Transition Aggregate Functions (WIP)
Date: 2014-01-25 23:24:43
Message-ID: CAApHDvqFaqAoc-op5dC0YF8BKDTBveEYs24d6qvxOcjnfzUL_A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Jan 25, 2014 at 3:21 PM, Florian Pflug <fgp(at)phlo(dot)org> wrote:

> On Jan24, 2014, at 08:47 , Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> wrote:
> The invtrans_minmax patch doesn't contain any patches yet - David, could
> you provide some for these functions, and also for bool_and and bool_or?
> We don't need to test every datatype, but a few would be nice.
>
>
I've added a few regression tests for min, min and bool_or and bool_and.
I've pushed these up to here:

https://github.com/david-rowley/postgres/commits/invtrans_minmax

I did wonder if you'd want to see uses of FILTER in there as I'm thinking
that should really be covered by the core patch and the tests here really
should just be checking the inverse transition functions for min and max.

As for the data types tested, I ended just adding tests for int and text
for min and max. Let me know if you think that more should be tested.

As for bool_or and bool_and. I didn't think there was much extra that would
need tested after I added 1 test. It's pretty simple code and adding
anything extra seems like it would be testing something else.

Regards

David Rowley

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2014-01-26 00:03:09 Re: Storing pg_stat_statements query texts externally, pg_stat_statements in core
Previous Message Simon Riggs 2014-01-25 23:08:32 Re: A better way than tweaking NTUP_PER_BUCKET