Re: How to make a REALLY FAST db server? - Mailing list pgsql-general

From Andrew Snow
Subject Re: How to make a REALLY FAST db server?
Date
Msg-id 20011207111739.F1264-100000@esper.modulus.org
Whole thread Raw
In response to Re: How to make a REALLY FAST db server?  (Tomaz Borstnar <tomaz.borstnar@over.net>)
Responses Re: How to make a REALLY FAST db server?
Re: How to make a REALLY FAST db server?
List 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 by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Casting Varchar to Numeric
Next
From: Ken
Date:
Subject: Errors: Too many open files