Re: why does count take so long?

Greg Stark <gsstark@mit.edu>

From: Greg Stark <gsstark@mit.edu>
To: pgsql-general@postgresql.org
Date: 2003-09-08T21:15:48Z
Lists: pgsql-general
Tom Lane <tgl@sss.pgh.pa.us> writes:

> Something I've wanted to do for awhile is to look at making int8 and
> float8 be pass-by-value datatypes on machines where Datum is naturally
> 8 bytes (ie, any 8-byte-pointer architecture).  I doubt it would be a
> win to widen Datum on 32-bit machines, though; the distributed costs
> would swamp the advantage from making these datatypes more efficient.

Things like count(*) could use int4 until it overflows though. 
Is int4 a pass-by-value datatype on 32-bit machines?

-- 
greg