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

From Bruce Momjian
Subject Re: How to make a REALLY FAST db server?
Date
Msg-id 200112101034.fBAAYLr03426@candle.pha.pa.us
Whole thread Raw
In response to Re: How to make a REALLY FAST db server?  (Andrew Snow <andrew@modulus.org>)
List pgsql-general
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.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
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

--
  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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: alternative place to download pgaccess
Next
From: Bruce Momjian
Date:
Subject: Re: DEBUG messages