Re: Row Limit on tables

Thank you for your replies. We have eclipsed the 200 Million mark in our
table. I have read the FAQ's about Postgres that stated there was no limit
on the number of rows, and that the size of the database would be limited to
the size of your Hard drives only.

The performance of select queries has not degregraded as much as I expected.
The indexes are doing their job.

Sheheryar Sewani

----Original Message Follows----
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "shey sewani" <pakix2000(at)hotmail(dot)com>
CC: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Row Limit on tables
Date: Fri, 31 May 2002 13:39:37 -0400
Received: from [192.204.191.242] by hotmail.com (3.2) with ESMTP id
MHotMailBEC1005C00BF4004321EC0CCBFF204920; Fri, 31 May 2002 10:39:41 -0700
Received: from sss2.sss.pgh.pa.us (tgl(at)localhost [127.0.0.1])by
sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g4VHdcW19260;Fri, 31 May 2002
13:39:38 -0400 (EDT)
>From tgl(at)sss(dot)pgh(dot)pa(dot)us Fri, 31 May 2002 10:40:53 -0700
In-reply-to: <F166kmx42WGYwvimdzh00004a2d(at)hotmail(dot)com>
References: <F166kmx42WGYwvimdzh00004a2d(at)hotmail(dot)com>
Comments: In-reply-to "shey sewani" <pakix2000(at)hotmail(dot)com>message dated
"Fri, 31 May 2002 10:25:48 -0500"
Message-ID: <19257(dot)1022866777(at)sss(dot)pgh(dot)pa(dot)us>

"shey sewani" <pakix2000(at)hotmail(dot)com> writes:
> Is there a limit on the number of rows you can have in a table?

http://www.ca.postgresql.org/docs/faq-english.html#4.5

The smallest useful row size would probably be 40 bytes (2 int columns
plus 32 bytes overhead), so 16TB/40 = 400 billion rows is the most you
could possibly fit given the table size limit (unless you raise BLCKSZ
to 32K, which would give you another factor of 4).

In practice, "what will fit on your disk" is the limit.

> Couple experts have predicted that 20Million or 200Million was the
> limit.

These "experts" evidently have no clue what they are talking about.
Perhaps they neglected to read the thread running parallel to this
one that mentions throwaway tests on 500M-row tables...

I saw nearby a claim that count(*) would fail at 2G rows --- but
count(*) returns int8 in 7.2 and later.

regards, tom lane

Sheheryar Sewani
Houston, TX

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.