Re: Ideal hardware configuration for pgsql - Mailing list pgsql-general

From teg@redhat.com (Trond Eivind Glomsrød)
Subject Re: Ideal hardware configuration for pgsql
Date
Msg-id xuy4rv2f5o4.fsf@halden.devel.redhat.com
Whole thread Raw
In response to Re: Ideal hardware configuration for pgsql  ("Steve Wolfe" <steve@iboats.com>)
List pgsql-general
"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.

pgsql-general by date:

Previous
From: Michelle Murrain
Date:
Subject: Re: Ideal hardware configuration for pgsql
Next
From: Lieven Van Acker
Date:
Subject: Re: View permissions in 7.1