Re: Ideal hardware configuration for pgsql

Поиск
Список
Период
Сортировка
От teg@redhat.com (Trond Eivind Glomsrød)
Тема Re: Ideal hardware configuration for pgsql
Дата
Msg-id xuy4rv2f5o4.fsf@halden.devel.redhat.com
обсуждение исходный текст
Ответ на Re: Ideal hardware configuration for pgsql  ("Steve Wolfe" <steve@iboats.com>)
Список 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 по дате отправления:

Предыдущее
От: Michelle Murrain
Дата:
Сообщение: Re: Ideal hardware configuration for pgsql
Следующее
От: Lieven Van Acker
Дата:
Сообщение: Re: View permissions in 7.1