Re: [PATCHES] Avg performance for int8/numeric - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: [PATCHES] Avg performance for int8/numeric
Date
Msg-id 1164559292.3778.22.camel@silverbirch.site
Whole thread Raw
In response to Re: [PATCHES] Avg performance for int8/numeric  (Mark Kirkwood <markir@paradise.net.nz>)
Responses Re: [PATCHES] Avg performance for int8/numeric  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sat, 2006-11-25 at 18:57 +1300, Mark Kirkwood wrote:
> Also Neil suggested investigating using a single composite type
> {int8, 
> numeric} for the {N,sum(X)} transition values. This could well be a 
> faster way to do this (not sure how to make it work yet... but it
> sounds 
> promising...).

If that is true it implies that any fixed length array is more expensive
than using a composite type. Is there something to be gained by changing
the basic representation of arrays, rather than rewriting all uses of
them?

--  Simon Riggs              EnterpriseDB   http://www.enterprisedb.com




pgsql-hackers by date:

Previous
From: "Jeroen T. Vermeulen"
Date:
Subject: "Optional ident" authentication
Next
From: David Boreham
Date:
Subject: Re: Integrating Replication into Core