Horton

Re: Various performance questions

Neil Conway <neilc@samurai.com>

View thread View on postgr.es
From: Neil Conway <neilc@samurai.com>
To: Greg Stark <gsstark@mit.edu>
Cc: Dror Matalon <dror@zapatec.com>, PostgreSQL Performance <pgsql-performance@postgresql.org>
Date: 2003-10-27T15:41:49Z
Lists: pgsql-performance 
On Sun, 2003-10-26 at 22:49, Greg Stark wrote:
> What version of postgres is this?. In 7.4 (and maybe 7.3?) count() uses an
> int8 to store its count so it's not limited to 4 billion records.
> Unfortunately int8 is somewhat inefficient as it has to be dynamically
> allocated repeatedly.

Uh, what? Why would an int8 need to be "dynamically allocated
repeatedly"?

-Neil