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

From Martijn van Oosterhout
Subject Re: How to make a REALLY FAST db server?
Date
Msg-id 20010928092314.B32426@svana.org
Whole thread Raw
In response to Re: How to make a REALLY FAST db server?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: How to make a REALLY FAST db server?
Next
From: Arcady Genkin
Date:
Subject: Re: Authenticating user `postgres'