How many rows can postgresql can sustain

From: Kumar S <ps_postgres(at)yahoo(dot)com>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: How many rows can postgresql can sustain
Date: 2004-10-13 16:14:11
Message-ID: 20041013161411.29502.qmail@web51410.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Dear group,
I am wondering how many rows of data can postgresql
efficiently deal with in comparision to Oracle that
can deal with millions and millions of rows (I was
told this fact by my senior).

One of my table has 8876216 rows that look like:
affy_id | exp_id | exp_chip_id | affy_x | affy_y |
affy_mean | affy_stdv | affy_npixels
---------+--------+-------------+--------+--------+-----------+-----------+--------------
8676216 | | 58 | 249 | 159 |
527.5 | 92.3 | 36

max
---------
8876216
(1 row)

Is there any upper limit where depending on number of
rows one can say that table (database) is crossing
limits or really bulky.

-Kumar.


_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2004-10-13 16:31:21 Re: How many rows can postgresql can sustain
Previous Message Andreas 2004-10-13 14:36:33 Re: possible to access a Linux box db from a Windows box