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