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(at)cynic(dot)net]
Sent: Friday, May 31, 2002 10:23 AM
To: shey sewani
Cc: pgsql-general(at)postgresql(dot)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(at)cynic(dot)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(at)postgresql(dot)org