pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Suggested HW for postgres ?
3+ messages / 3 participants
[nested] [flat]

* Suggested HW for postgres ?
@ 2005-11-18 19:05 Enrico Weigelt <weigelt@metux.de>
  2005-11-18 19:50 ` Re: Suggested HW for postgres ? Scott Marlowe <smarlowe@g2switchworks.com>
  2005-11-18 20:08 ` Re: Suggested HW for postgres ? Joel Stevenson <joelstevenson@mac.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Enrico Weigelt @ 2005-11-18 19:05 UTC (permalink / raw)
  To: pgsql-admin


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/
---------------------------------------------------------------------



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Suggested HW for postgres ?
  2005-11-18 19:05 Suggested HW for postgres ? Enrico Weigelt <weigelt@metux.de>
@ 2005-11-18 19:50 ` Scott Marlowe <smarlowe@g2switchworks.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Scott Marlowe @ 2005-11-18 19:50 UTC (permalink / raw)
  To: weigelt@metux.de; +Cc: pgsql-admin

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?  



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Suggested HW for postgres ?
  2005-11-18 19:05 Suggested HW for postgres ? Enrico Weigelt <weigelt@metux.de>
@ 2005-11-18 20:08 ` Joel Stevenson <joelstevenson@mac.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Joel Stevenson @ 2005-11-18 20:08 UTC (permalink / raw)
  To: pgsql-admin

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.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2005-11-18 20:08 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-11-18 19:05 Suggested HW for postgres ? Enrico Weigelt <weigelt@metux.de>
2005-11-18 19:50 ` Scott Marlowe <smarlowe@g2switchworks.com>
2005-11-18 20:08 ` Joel Stevenson <joelstevenson@mac.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox