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

From Mark Kirkwood
Subject Re: Avg performance for int8/numeric
Date
Msg-id 4567A07B.6010900@paradise.net.nz
Whole thread Raw
In response to Re: Avg performance for int8/numeric  ("Luke Lonergan" <llonergan@greenplum.com>)
Responses Re: Avg performance for int8/numeric  (Mark Kirkwood <markir@paradise.net.nz>)
List pgsql-patches
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

pgsql-patches by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: Avg performance for int8/numeric
Next
From: Mark Kirkwood
Date:
Subject: Re: Avg performance for int8/numeric