Skip site navigation (1) Skip section navigation (2)

Hardware needed for 15,000,000 record DB?

From: <pdg(at)stratos(dot)net>
To: <pgsql-novice(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org>
Subject: Hardware needed for 15,000,000 record DB?
Date: 2002-04-21 23:25:02
Message-ID: 018e01c1e98b$c65771b0$0a00000a@windowsbox (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-novice
Hello,  :-)

Can someone help me spec out the hardware needed for a simple web-based
database app?

Basically, that application needs to lookup a single row by its primary key.
This would be fairly straightforward, except that the table needs to contain
up to 15 million records.  Each row will contain approximately 25  variable
length CHAR fields with perhaps a total of 3 to 4 kilobytes of data per row.

Updates will be done nightly via some sort of a batch process.

What kind of hardware would be needed for this sort of application? The
queries are not complex, it's just a lot of data.

Would a midrange Celeron processor with 256 MB RAM be sufficient? How would
backups work for a database this large?

Is PostgreSQL even the best database engine for this app? Perhaps MySQL? Or
maybe a Microsoft solution?

Thanks so much,
David


Responses

pgsql-novice by date

Next:From: Mathieu ArnoldDate: 2002-04-22 06:29:57
Subject: Re: [NOVICE] Hardware needed for 15,000,000 record DB?
Previous:From: P. JourdanDate: 2002-04-21 21:44:06
Subject: oh - oh

pgsql-admin by date

Next:From: Rommel B. AbayaDate: 2002-04-22 00:37:23
Subject: Re: Database mirroring
Previous:From: Oliver ElphickDate: 2002-04-21 19:00:54
Subject: Re: Upgrading from 7.1.2 to 7.2.1 on new server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group