Re: How to make a REALLY FAST db server?

Поиск
Список
Период
Сортировка
От Andrew Snow
Тема Re: How to make a REALLY FAST db server?
Дата
Msg-id 20011207111739.F1264-100000@esper.modulus.org
обсуждение исходный текст
Ответ на Re: How to make a REALLY FAST db server?  (Tomaz Borstnar <tomaz.borstnar@over.net>)
Ответы Re: How to make a REALLY FAST db server?  ("Robert J. Sanford, Jr." <rsanford@nolimitsystems.com>)
Re: How to make a REALLY FAST db server?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
FWIW, I have some IBM-DPTA-372050 and after enabling TCQ with FreeBSD
I barely noticed any improvement, and occasionally strange error messages
appeared, so I disabled it again.  I believe you need more recent
drives (with updated firmware, no doubt) to get any performance gain..

- Andrew


On Thu, 6 Dec 2001, Tomaz Borstnar wrote:

> At 18:35 27.9.2001, Bruce Momjian wrote the following message:
> >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.
>
> IBM Deskstar drives DPTA and DLTA and new IC35 all have tagged queuing.
> FreeBSD supports that and the results are impressive - lower CPU usage and
> faster disks.
>
>
>
> ----
> Tomaz Borstnar <tomaz.borstnar@over.net>
> "Love is the answer to the final question you ask" - Unknown
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>


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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Casting Varchar to Numeric
Следующее
От: Ken
Дата:
Сообщение: Errors: Too many open files