Re: Row Limit on tables

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