Re: How many rows can postgresql can sustain - Mailing list pgsql-novice

From Oliver Fromme
Subject Re: How many rows can postgresql can sustain
Date
Msg-id 200410131638.i9DGc76R009609@lurza.secnetix.de
Whole thread Raw
In response to How many rows can postgresql can sustain  (Kumar S <ps_postgres@yahoo.com>)
List pgsql-novice
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)

pgsql-novice by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: How many rows can postgresql can sustain
Next
From: Daniel Lerch
Date:
Subject: connecting with pgAdmin II