Re: How to make a REALLY FAST db server?

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: How to make a REALLY FAST db server?
Дата
Msg-id 20010928092314.B32426@svana.org
обсуждение исходный текст
Ответ на Re: How to make a REALLY FAST db server?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
On Thu, Sep 27, 2001 at 03:35:09PM -0400, Bruce Momjian wrote:
> > 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.

From what I gather from reading lkml, recent ATA standards do include such
capabilities. Whether it is supports by the drivers, controllers and disks
is another matter entirely. But it is there.

--
Martijn van Oosterhout <kleptog@svana.org>
http://svana.org/kleptog/
> Magnetism, electricity and motion are like a three-for-two special offer:
> if you have two of them, the third one comes free.

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: How to make a REALLY FAST db server?
Следующее
От: Arcady Genkin
Дата:
Сообщение: Re: Authenticating user `postgres'