Re: How to make a REALLY FAST db server?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: How to make a REALLY FAST db server?
Дата
Msg-id 200109271935.f8RJZ9i16585@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: How to make a REALLY FAST db server?  ("Marshall Spight" <marshall@meetstheeye.com>)
Ответы Re: How to make a REALLY FAST db server?
Re: How to make a REALLY FAST db server?
Список pgsql-general
> >    (Not to mention the fact that IDE drives only do well when a single
> > process is accessing them.  SCSI, having been designed from the gound up
> > for this sort of thing, does much better when you're hitting the disks
> > from several places at once.)
>
>
> Do you have any hard data to back this up? I'd be interested.
>
> Usually when this question is asked, the response is "well,
> I've run a lot of servers, and they just seem faster." But I'm
> only interested in hard data.

Well, SCSI with tagged queueing allows you to send multiple disk
requests to the drive and the drive orders them to be optimal.  Only the
drive knows there the head it at a given moment so it seems good to push
such optimizations into the disk drive.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@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 по дате отправления:

Предыдущее
От: "Daniel A. Morgan"
Дата:
Сообщение: Re: NewYork Bombing: SQL server bomb proof!!
Следующее
От: "Mihai Gheorghiu"
Дата:
Сообщение: Successful EXECUTE