Re: Row Limit on tables - Mailing list pgsql-general

From McCaffity, Ray (Contractor)
Subject Re: Row Limit on tables
Date
Msg-id 9669B05099E9D411B6E400B0D0AA476C5C3855@epg.lewis.army.mil
Whole thread Raw
In response to Row Limit on tables  ("shey sewani" <pakix2000@hotmail.com>)
List pgsql-general
I'd like to see the EXPLAIN on a VIEW for this.  :-)

Ray

-----Original Message-----
From: Curt Sampson [mailto:cjs@cynic.net]
Sent: Friday, May 31, 2002 10:23 AM
To: shey sewani
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Row Limit on tables


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.

Nowhere near that low, that's for sure. I'm playing with a 500
million row table right now. And this is just on a single cheap
IDE disk, not on real hardware that would let me work with properly
large databases....

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

pgsql-general by date:

Previous
From: Curt Sampson
Date:
Subject: Re: Row Limit on tables
Next
From: Tom Lane
Date:
Subject: Re: Row Limit on tables