Re: How to make a REALLY FAST db server?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: Marshall Spight <marshall(at)meetstheeye(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: How to make a REALLY FAST db server?
Date: 2001-09-27 23:46:41
Message-ID: 200109272346.f8RNkfg18862@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

The ATA system basically has the disk controller in the CPU while SCSI
has commands that you send to the drive and the drive implements them.
Not sure how you could implement tagged queueing with the ATA system.

--
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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-09-28 00:16:17 Re: temp table::persistance problem
Previous Message Martijn van Oosterhout 2001-09-27 23:33:03 Re: PostGres is not using indices in select, I would like it to because it is too slow !