Re: [GENERAL] Maximum Records

On Wed, 26 May 1999, Dannie M Stanley wrote:

> I am currently considering using PostgreSQL to facilitate a large database.
> I need to know if there is a maximum number of records.  Or if there is a
> point at which the performance is severely cut.  The database that I need to
> implement will start at around 30,000 records.  If anyone could point me to
> performance comparisons or documentation on such information I would
> appreciate it.

You should have no problems.  I have a database with 7 or 8 tables, most
of which have over a million rows.  One table has over 2 million rows.
Performance is pretty good, especially if you index things properly.  I
have a web interface to this data, via PHP3, and it takes only a few
minutes to run the queries form the web page and generate statistical
data.  It's only running under Linux on a PPro 200, with 128 megs of RAM.

Brett W. McCoy
                                        http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
Dinner suggestion #302 (Hacker's De-lite):
    1 tin imported Brisling sardines in tomato sauce
    1 pouch Chocolate Malt Carnation Instant Breakfast
    1 carton milk