Re: seq scan cache vs. index cache smackdown

From: PFC <lists(at)boutiquenumerique(dot)com>
To: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Magnus Hagander" <mha(at)sollentuna(dot)net>
Cc: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>, "Josh Berkus" <josh(at)agliodbs(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: seq scan cache vs. index cache smackdown
Date: 2005-03-01 05:32:14
Message-ID: opsmx1n0mnth1vuj@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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

Nope, readv()/writev() read/write from/to the file sequentially to/from a
list of buffers in memory. The Windows calls read/write at random file
offsets to/from a list of buffers.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Ramon Bastiaans 2005-03-01 09:34:29 multi billion row tables: possible or insane?
Previous Message John Arbash Meinel 2005-03-01 01:41:20 Re: Inheritence versus delete from