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
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 |