Re: [ADMIN] Hardware for a database server

2004-03-16 Thread Erwin Brandstetter
Yo Scott, Greg & William! I tried to send the following message last week, but my posting never got here. Guess my provider has fucked up. So here goes again, sorry for late reply. For knowledgeable feedback I have asked, and that's what I have got. Thanx a lot. My thanks also Jim Wilson who ad

Re: [ADMIN] Hardware for a database server

2004-03-10 Thread Greg Spiegelberg
scott.marlowe wrote: On Wed, 10 Mar 2004, Erwin Brandstetter wrote: Controller / Hard Discs: RAID 5 with 4+ discs including a hot spare. But SCSI or SATA? I am undecided on this. Until about a year ago, I would have said SCSI, period. But I have read of SATA RAIDs for entry-level-servers doing q

Re: [ADMIN] Hardware for a database server

2004-03-10 Thread William Yu
Erwin Brandstetter wrote: CPU: Single AMD Opteron. Opteron, because i plan to migrate to amd64 debian as soon as Debian has a stable release. Single, because multi-CPU would only make sense if the CPU could ever get the bottleneck. But I don't have to fear that, right? No need for a dual-cpu set

Re: [ADMIN] Hardware for a database server

2004-03-10 Thread scott.marlowe
On Wed, 10 Mar 2004, Erwin Brandstetter wrote: > Hi List! Howdy! > Short version: > It is for a medium sized database. ~ 50 users, < 5GB, biggest table < 1 > million tupples, 60 tables, lots of indices, triggers, rules, and other > objects. SNIP! > What will I purchase? > > CPU: > Single AM

[ADMIN] Hardware for a database server

2004-03-09 Thread Erwin Brandstetter
Hi List! I have to purchase new hardware for my company's new dedicated PG database server. As it is my first time shopping for this special purpose, I would feel less nervous if I could get some knowledgeable feedback on this matter. What is it for? Short version: It is for a medium sized d