Hi,
On Fri, 31 May 2002, shey sewani wrote:
>
>
> Is there a limit on the number of rows you can have in a table?
> Couple experts have predicted that 20Million or 200Million was the limit. I
> would like to hear your expereinces.
>
> My machine is a Redhat 7.1 x86 Box running Postgres7.1.2
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".
That's why numbger of rows in a table is only limited to your available
physical disk space or swap.
Best regards.
--
Devrim GUNDUZ
devrim@oper.metu.edu.tr
devrim.gunduz@linux.org.tr
Web : http://devrim.oper.metu.edu.tr
-------------------------------------