Re: why does count take so long? - Mailing list pgsql-general

From Greg Stark
Subject Re: why does count take so long?
Date
Msg-id 87he3n56d7.fsf@stark.dyndns.tv
Whole thread Raw
In response to Re: why does count take so long?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: why does count take so long?
List 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

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: decrypted pwd
Next
From: Ron Johnson
Date:
Subject: Re: Can I use PostgreSQL to develop a self-organizing