Re: Improving avg performance for numeric

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Hadi Moshayedi <hadi(at)moshayedi(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Kevin Grittner <kgrittn(at)ymail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, "mark(dot)kirkwood(at)catalyst(dot)net(dot)nz" <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
Subject: Re: Improving avg performance for numeric
Date: 2013-07-08 17:32:26
Message-ID: CAFj8pRAF5Yx=MzZR=pEv=OD5OSgqoinsuanHnxS8R9zd2o--ZA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello

2013/7/8 Josh Berkus <josh(at)agliodbs(dot)com>:
> On 07/07/2013 09:14 PM, Hadi Moshayedi wrote:
>> I am attaching the updated the patch, which also fixes a bug which
>> caused one of the regression tests failed.
>>
>> I'll subscribe this patch to the commitfest in the next hour.
>>
>> Can you please review the patch?
>
> I'm afraid that, since this patch wasn't included anywhere near the
> first week of the CommitFest, I can't possibly include it in the June
> commitfest now. Accordingly, I have moved it to the September
> commitfest. Hopefully someone can look at it before then.
>
> Sorry for missing this in my "patch sweep" at the beginning of the CF.
> Searching email for patches is, at best, inexact.
>

sure, it should be in September CF. It is relative simple patch
without global impacts. But I like it, it increase speed for
sum(numeric) about 25% and avg(numeric) about 50%

Regards

Pavel

> --
> Josh Berkus
> PostgreSQL Experts Inc.
> http://pgexperts.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2013-07-08 17:35:27 Re: pg_filedump 9.3: checksums (and a few other fixes)
Previous Message Jeff Davis 2013-07-08 17:28:25 Re: pg_filedump 9.3: checksums (and a few other fixes)