Re: seq scan cache vs. index cache smackdown - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: seq scan cache vs. index cache smackdown
Date
Msg-id 200502190411.j1J4B8T15005@candle.pha.pa.us
Whole thread Raw
In response to Re: seq scan cache vs. index cache smackdown  ("Magnus Hagander" <mha@sollentuna.net>)
Responses Re: seq scan cache vs. index cache smackdown
List pgsql-performance
Magnus Hagander wrote:
> I don't think that's correct either. Scatter/Gather I/O is used to SQL
> Server can issue reads for several blocks from disks into it's own
> buffer cache with a single syscall even if these buffers are not
> sequential. It did make significant performance improvements when they
> added it, though.
>
> (For those not knowing - it's ReadFile/WriteFile where you pass an array
> of "this many bytes to this address" as parameters)

Isn't that like the BSD writev()/readv() that Linux supports also?  Is
that something we should be using on Unix if it is supported by the OS?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-performance by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: PostgreSQL clustering VS MySQL clustering
Next
From: "Rodrigo Moreno"
Date:
Subject: RES: RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin