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

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [GENERAL] advice on buying sun hardware to run postgres
Дата
Msg-id 199904261847.OAA02263@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] advice on buying sun hardware to run postgres  (Dustin Sallings <dustin@spy.net>)
Список pgsql-general
>     Works != works as well as SCSI.  I've yet to find an example where
> IDE works as well as SCSI in real life (vs. benchmarks).  My real life
> scenarios rarely involve telling a machine to be still so we can do a disk
> read, then again for a disk write.

Probably true.  IDE can not access more than one drive at a time, and
requires CPU to complete the data transfers.

>
> # People have been commenting lately that postgres on Solaris is very slow
> # compared to Linux. Apparently certain file system operations on Solaris
> # is _slow_.
>
>     Slow, however more robust than the same in Linux.  Linux achieves
> a lot of speed by throwing away safety nets.  Sometimes, these safety nets
> are important.

Yes, it is hard to write code that is fast for small cases, but scales
well for large cases.  It can be done, it is just not easy.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

В списке pgsql-general по дате отправления:

Предыдущее
От: Dustin Sallings
Дата:
Сообщение: Re: [GENERAL] advice on buying sun hardware to run postgres
Следующее
От: sobrien@id.jefferson.co.us ()
Дата:
Сообщение: Re: JPEG Files In Postgres Database