Re: Various performance questions

Neil Conway <neilc@samurai.com>

From: Neil Conway <neilc@samurai.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Greg Stark <gsstark@mit.edu>, Dror Matalon <dror@zapatec.com>, PostgreSQL Performance <pgsql-performance@postgresql.org>
Date: 2003-10-27T18:54:50Z
Lists: pgsql-performance
On Mon, 2003-10-27 at 13:52, Tom Lane wrote:
> Greg is correct.  int8 is a pass-by-reference datatype and so every
> aggregate state-transition function cycle requires at least one palloc
> (to return the function result).

Interesting. Is there a reason why int8 is pass-by-reference? (ISTM that
pass-by-value would be sufficient...)

Thanks for the information, Tom & Greg.

-Neil