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