Re: How to make a REALLY FAST db server?

You have to use zero rotation delay to newfs to see an improvement. Do
you have that?

---------------------------------------------------------------------------

>
> 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(dot)borstnar(at)over(dot)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(at)postgresql(dot)org so that your
> > message can get through to the mailing list cleanly
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

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