Re: Various performance questions - Mailing list pgsql-performance

From Neil Conway
Subject Re: Various performance questions
Date
Msg-id 1067269309.459.33.camel@tokyo
Whole thread Raw
In response to Re: Various performance questions  (Greg Stark <gsstark@mit.edu>)
Responses Re: Various performance questions  (Greg Stark <gsstark@mit.edu>)
List 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



pgsql-performance by date:

Previous
From: Neil Conway
Date:
Subject: Re: Various performance questions
Next
From: Vivek Khera
Date:
Subject: Re: My own performance/tuning q&a