From: | Ken Gunderson <webweaver(at)rmci(dot)net> |
---|---|
To: | "Adam Rossi" <adam(dot)rossi(at)platinumsolutions(dot)com>, <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] server hardware recommendations (the archives are dead) |
Date: | 1999-12-15 16:51:07 |
Message-ID: | 3.0.6.32.19991215095107.01331100@rmci.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
At 08:41 AM 12/15/99 -0500, Adam Rossi wrote:
>I know this question has been asked before. I have seen it in the archives.
>Unfortunately the archives are dead right now (any search will yield "no
>results") and I need to make some decisions.
>
>Can anyone give some general recommendations on hardware for a server
>running Linux (RH6 or 6.1) and PostgreSQL? I estimate that there will be
>about 2 GIG of data stored in the database initially, but this could grow as
>high as 5 GIG in the future.
>
>Since the db is not multithreaded, I assume that buying a dual processor
>board and two processors would not be helpful to performance. Like any
>database server, a lot of ram will be required for fast operation. I was
>thinking at a minimum 256 meg of ram. I also want to have the database run
>on a RAID 5 array for speed and fault tolerance. Any suggestions here for
>disk type, RAID scheme (software or hardware), controller type, etc.? Any
>rule of thumb on the "extra" disk space needed above raw storage space for
>PostgreSQL operations (temporary tables, vacuum issues, etc)?
>
>Any past experiences, benchmarks, guesses, or hearsay gladly accepted.
>Thanks for your help.
I think you may want to consider a software based volume manager (e.g.
Veritas) and run a stripped mirror (RAID 10) rather than RAID 5. This will
help out on writes. I'm not into RH, but surely they must offer something
comparable to FreeBSD's Vinum. If not, I know Debian has one available.
Ciao-- Ken
http://www.y2know.org/safari
Failure is not an option. It comes bundled with your
Microsoft product.
From | Date | Subject | |
---|---|---|---|
Next Message | Ross J. Reedstrom | 1999-12-15 16:59:52 | Re: [GENERAL] server hardware recommendations (the archives aredead) |
Previous Message | The Hermit Hacker | 1999-12-15 16:27:44 | Re: [GENERAL] server hardware recommendations (the archives aredead) |