Skip site navigation (1) Skip section navigation (2)

Re: Various performance questions

From: Neil Conway <neilc(at)samurai(dot)com>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: Dror Matalon <dror(at)zapatec(dot)com>,PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Various performance questions
Date: 2003-10-27 15:41:49
Message-ID: 1067269309.459.33.camel@tokyo (view raw or flat)
Thread:
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



In response to

Responses

pgsql-performance by date

Next:From: Vivek KheraDate: 2003-10-27 16:03:35
Subject: Re: My own performance/tuning q&a
Previous:From: Neil ConwayDate: 2003-10-27 15:34:53
Subject: Re: Various performance questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group