Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimizing numeric SUM() aggregate - Mailing list pgsql-hackers

From Andrew Borodin
Subject Re: Optimizing numeric SUM() aggregate
Date
Msg-id CAJEAwVGNmZccOv91sNC+oX+Y4rtJRvsfzJO=h-jj=-Mrfckodw@mail.gmail.com
Whole thread Raw
In response to Optimizing numeric SUM() aggregate  (Heikki Linnakangas <hlinnaka@iki.fi>)
Responses Re: Optimizing numeric SUM() aggregate  (Andrew Borodin <borodin@octonica.com>)
List pgsql-hackers
Tree view 
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.

pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Confusing TAP tests readme file
Next
From: Amit Kapila
Date:
Subject: Re: AdvanceXLInsertBuffer vs. WAL segment compressibility