Thank you much for the info.
I will take a look. I think the prices I have been seeing may exclude us
getting another 4 proc box this soon. My boss asked me to get something in
the 15K range (I spent 30 on the Dell).
The HP seemed to run around 30 but it had a lot more drives then the dell
(speced it with 14 10k drives).
I can and will most likely build it myself to try getting a bit more bang
for the buck and it is a second server so if it dies it should not be a
FYI everyone using our system (after a week of dealing with many bugs) have
been saying how much they like the speed.
I did have to do a lot of creative ideas to get it working in a way that
appears faster to the client.
Stuff like the queries default to limit 50 and as they hit next I up the
limit (also a flag to just show all records and a count, it used to default
to that). The two worst queries (our case and audit applications) I created
denormalized files and maintain them through code. All reporting comes off
those and it is lightning fast.
I just want to say again thanks to everyone who has helped me in the past
2520 Trailmate Dr
Sarasota, Florida 34243
Tel. 941-753-7111 ext 305
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
This email message is for the use of the intended recipient(s) and may
contain confidential and privileged information. Any unauthorized review,
use, disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and delete and destroy
all copies of the original message, including attachments.
From: David Brown [mailto:time(at)bigpond(dot)net(dot)au]
Sent: Friday, May 13, 2005 7:03 PM
To: Joel Fradkin
Subject: Re: [PERFORM] ok you all win what is best opteron (I dont want a
hosed system again)
Joel Fradkin wrote:
> Is the battery backed cache good or bad for Postgres?
Battery-backed avoids corruption if you have an unexpected power loss.
It's considered mandatory with large-cache write-back controllers if you
can't afford to lose any data.
> They are telling me I can only get a duel channel card if I want
> hardware raid 10 on the 14 drives.
> I can get two cards but it has to be 7 and 7 (software raid?) which
> does not sound like it fixes my single point of failure (one of the
> listers mentioned my current system has 3 such single points).
Sounds like you need to try another vendor. Are you aiming for two RAID
10 arrays or one RAID 10 and one RAID 5?
> Any of you hardware gurus spell out the optimal machine (I am hoping
> to be around 15K, might be able to go more if it's a huge difference,
> I spent 30k on the Dell).
> I do not have to go HP, and after seeing the fail ratio from Monarch
> from one lister I am bit scared shopping there.
There's unlikely to be many common components between their workstation
and server offerings. You would expect case, power, graphics,
motherboard, storage controller and drives to all be different. But I'd
challenge that 50% failure stat anyway. Which components exactly? Hard
drives? Power supplies?
> Was there a conclusion on where is best to get one (I really want two
> one for development too).
Almost anyone can build a workstation or tower server, and almost anyone
else can service it for you. It gets trickier when you're talking 2U and
especially 1U. But really, these too can be maintained by anyone
competent. So I wonder about some people's obsession with
Realistically, most Opteron solutions will use a Tyan motherboard (no
idea if this includes HP). For 4-way systems, there's currently only the
S4882, which includes an LSI dual channel SCSI controller. Different
vendors get to use different cases and cooling solutions and pick a
different brand/model of hard drive, but that's about it.
Tyan now also sells complete servers - hardly a stretch seeing they
already make the most important bit (after the CPU). Given the level of
interest in this forum, here's their list of US resellers:
If it's a tower server, build it yourself or pay someone to do it. It
really isn't challenging for anyone knowledgeable about hardware.
In response to
pgsql-performance by date
|Next:||From: Josh Berkus||Date: 2005-05-14 21:19:15|
|Subject: Re: ok you all win what is best opteron (I dont want a hosed system again)|
|Previous:||From: Jim C. Nasby||Date: 2005-05-14 13:37:22|
|Subject: Re: Sort and index|