Quick Links

Re: Optimizing numeric SUM() aggregate

From:	Andrew Borodin <borodin(at)octonica(dot)com>
To:	Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Cc:	pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: Optimizing numeric SUM() aggregate
Date:	2016-07-26 12:27:13
Message-ID:	CAJEAwVGNmZccOv91sNC+oX+Y4rtJRvsfzJO=h-jj=-Mrfckodw@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-hackers

Hi!

I like the idea and implementation, but I have one suggestion.
> Instead of propagating carry after each new value, it's done only every 9999 values (or at the end).

I think we could do carry every 0x7FFFFFF / 10000 accumulation, couldn't we?

Best regards, Andrey Borodin, Octonica & Ural Federal University.

In response to

Optimizing numeric SUM() aggregate at 2016-07-25 10:45:58 from Heikki Linnakangas

Responses

Re: Optimizing numeric SUM() aggregate at 2016-07-27 06:33:03 from Andrew Borodin

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Amit Kapila	2016-07-26 12:48:46	Re: AdvanceXLInsertBuffer vs. WAL segment compressibility
Previous Message	Fujii Masao	2016-07-26 12:18:30	Re: Confusing TAP tests readme file