Обсуждение: Suggested HW for postgres ?
Hi folks, we're going to buy new hardware for an postgresql database server. High availability is important, so I'm thinking of an Athlon System w/ 2GB RAM and UW-SCSI RAID. But what hardware should I use ? And what RAID configuration would be the best ? cu -- --------------------------------------------------------------------- Enrico Weigelt == metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: contact@metux.de --------------------------------------------------------------------- Realtime Forex/Stock Exchange trading powered by postgreSQL :)) http://www.fxignal.net/ ---------------------------------------------------------------------
On Fri, 2005-11-18 at 13:05, Enrico Weigelt wrote: > Hi folks, > > > we're going to buy new hardware for an postgresql database server. > High availability is important, so I'm thinking of an > Athlon System w/ 2GB RAM and UW-SCSI RAID. > > But what hardware should I use ? > And what RAID configuration would be the best ? Generally, a good battery backed SCSI / SATA based RAID card is recommended, ECC memory, and a whole bunch of drives. RAID10 is favored for Transaction processing, RAID5 for large reporting databases is a good compromise of performance and $/megabyte. 64 bit CPUs are very nice to have, especially with a 64 bit OS on top of them. What are you planning on doing with pgsql? How big is your dataset, how many users will hit it at once, those kinds of things?
At 8:05 PM +0100 11/18/05, Enrico Weigelt wrote: >Hi folks, > > >we're going to buy new hardware for an postgresql database server. >High availability is important, so I'm thinking of an >Athlon System w/ 2GB RAM and UW-SCSI RAID. > >But what hardware should I use ? >And what RAID configuration would be the best ? > Check out the long-running (still going) thread on the pgsql-performance list: http://archives.postgresql.org/pgsql-performance/2005-11/threads.php A lot of great about HW/OS there. Of course it really comes down to what you'll be using PG for.