Re: Ideal hardware configuration for pgsql

"Steve Wolfe" <steve@iboats.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.