Re: Avg performance for int8/numeric - Mailing list pgsql-patches

From Mark Kirkwood
Subject Re: Avg performance for int8/numeric
Date
Msg-id 4567A47E.7090205@paradise.net.nz
Whole thread Raw
In response to Re: Avg performance for int8/numeric  (Mark Kirkwood <markir@paradise.net.nz>)
List pgsql-patches
Mark Kirkwood wrote:
> Luke Lonergan wrote:
>> So, if I understand this correctly, we're calling Alloc and
>> ContextAlloc 10
>> times for every row being summed?
>>
>> There are approx 10M rows and the profile snippet below shows 100M
>> calls to
>> each of those.
>>
>
> Unless I've accidentally run gprof on the profile output for a 100M row
> case I had lying around :-( ... I'll check
>

I haven't (so profile as attached is ok)...

pgsql-patches by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: Avg performance for int8/numeric
Next
From: Joseph Shraibman
Date:
Subject: doc patch for savepoints