Re: Row Limit on tables

From: Doug Fields <dfields-pg-general(at)pexicom(dot)com>
To: Devrim GUNDUZ <devrim(at)oper(dot)metu(dot)edu(dot)tr>
Cc: shey sewani <pakix2000(at)hotmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Row Limit on tables
Date: 2002-06-02 00:04:39
Message-ID: 5.1.0.14.2.20020601200356.02cad6f0@mail.pexicom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


>I cannot remember the definition exactly; but as far as I remember, it was
>with count() function; which returns 32-bit integer, and for tables having
>more than 2 billion rows, count() has really no "meaning".

In 7.2.1 the aggregate functions now return longs (64-bit values).

Cheers,

Doug

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Doug Fields 2002-06-02 00:07:52 Re: Row Limit on tables
Previous Message murphy pope 2002-06-01 20:09:06 tid scan - is it ever used?