Re: Ideal hardware configuration for pgsql

"Steve Wolfe" <steve(at)iboats(dot)com> writes:

> 2. Disk type - use SCSI, not IDE. IDE takes too much CPU. If you're just
> trying to copy a file, that's not bad - but if you're trying to process DB
> queries at the same time, it's bad.

I'd drop SCSI and spend (some of) the difference for more RAM. IDE
performance when using DMA isn't bad at all.

> 4. CPU's - you may not need a 1 GHz. Find the "sweet spot", which is
> probably an 866 or 933. The difference won't be that great. If the
> difference between a 933 and a 1 GHz chip is going to make or break it, you
> probably need a quad-CPU solution to allow for growth and expansion.

As a general advice, that would be a good one... but the 1 GHz chips
are rather cheap nowadays, as they are more than a year old.

--
Trond Eivind Glomsrød
Red Hat, Inc.