Re: [PATCHES] Avg performance for int8/numeric

From: "Luke Lonergan" <llonergan(at)greenplum(dot)com>
To: "Mark Kirkwood" <markir(at)paradise(dot)net(dot)nz>
Cc: "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCHES] Avg performance for int8/numeric
Date: 2006-11-25 03:57:45
Message-ID: C18CFF39.E796%llonergan@greenplum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Mark,

On 11/24/06 6:16 PM, "Mark Kirkwood" <markir(at)paradise(dot)net(dot)nz> wrote:

> By way of comparison, here is the first 63 lines for:
>
> select sum(val2) from avgtest

So, sum() is only alloc'ing 5 times for every row being processed, half of
what avg() is doing.

Seems like what we need to do is find a way to reuse the temp heaptuple
between calls.

- Luke

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2006-11-25 04:49:18 dynahash API questions
Previous Message Luke Lonergan 2006-11-25 03:50:53 Re: [PATCHES] Avg performance for int8/numeric

Browse pgsql-patches by date

  From Date Subject
Next Message Mark Kirkwood 2006-11-25 05:57:51 Re: [PATCHES] Avg performance for int8/numeric
Previous Message Luke Lonergan 2006-11-25 03:50:53 Re: [PATCHES] Avg performance for int8/numeric