Re: How many rows can postgresql can sustain

Kumar S wrote:
 >  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:
 > [...]

Two weeks ago I fed the German telephone book of 2002 into
a PostgreSQL database (for testing purposes).  It was about
36 million rows and 8 GByte of data.  Of course, the import
took a while, but there were no problems at all.  I expect
PostgreSQL to cope with much more data than that.

Best regards
   Oliver

--
Oliver Fromme, secnetix GmbH & Co KG, Oettingenstr. 2, 80538 München
Any opinions expressed in this message may be personal to the author
and may not necessarily reflect the opinions of secnetix in any way.

"Clear perl code is better than unclear awk code; but NOTHING
comes close to unclear perl code"  (taken from comp.lang.awk FAQ)