From: | Devrim GUNDUZ <devrim(at)oper(dot)metu(dot)edu(dot)tr> |
---|---|
To: | shey sewani <pakix2000(at)hotmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Row Limit on tables |
Date: | 2002-05-31 16:15:19 |
Message-ID: | Pine.LNX.4.44.0205311911520.15535-100000@oper.metu.edu.tr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)oper(dot)metu(dot)edu(dot)tr
devrim(dot)gunduz(at)linux(dot)org(dot)tr
Web : http://devrim.oper.metu.edu.tr
-------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Nathan Everett Johnson | 2002-05-31 16:36:51 | How to Migrate from 7.1 to 7.2? |
Previous Message | Curt Sampson | 2002-05-31 16:10:13 | Re: Non-linear Performance |