Re: [GENERAL] advice on buying sun hardware to run postgres

dustin sallings wrote:

> Short answer: You are incorrect.
>
> Long answer: If you don't believe what people with experience with
> these things are saying, do your own experimentation.

It's not a matter of not believing, it's of who to believe. Opinion
seems divided 50/50.

> For best results,
> you can find some disks that are exactly the same internally but only vary
> with their interfaces.

Have you done such tests? If so, what exactly were the results?

> Try different things that might happen in the real
> world. I'd suggest starting by getting two machines, four disks, and one
> IDE controller, and one SCSI controller. Build one machine on IDE and one
> on SCSI. Do stuff like copying data from one disk to the other, install a
> database server (i.e. postgres) and do some benchmarks. Do it again while
> there's some activity on the other disk (i.e. build postgres) and see how
> it does. In fact, just run a make on each disk and see which system
> finishes first.
>
> // I've had the machine improperly shut down many many times for a
> // variety of reasons. I've never restored a file from backup and I've
> // never lost a file that I'm aware of. At least not that I can
> // remember, if I did it couldn't have been very important because I
> // didn't notice.
>
> *shrug* that's rare, then.
>
> --
> Principal Member Technical Staff, beyond.com The world is watching America,
> pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin(at)spy(dot)net>
> | Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
> L______________________________________________ and America is watching TV. __