Re: Asynchronous I/O Support - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: Asynchronous I/O Support
Date
Msg-id b42b73150610171018y3a80a088w9b221fad66c11190@mail.gmail.com
Whole thread Raw
In response to Re: Asynchronous I/O Support  ("Luke Lonergan" <llonergan@greenplum.com>)
List pgsql-hackers
On 10/15/06, Luke Lonergan <llonergan@greenplum.com> wrote:
> Martijn,
> The killer use-case we've identified is for the scattered I/O associated
> with index + heap scans in Postgres.  If we can issue ~5-15 I/Os in advance
> when the TIDs are widely separated it has the potential to increase the I/O
> speed by the number of disks in the tablespace being scanned.  At this
> point, that pattern will only use one disk.

did you have a chance to look at posix_fadvise?

merlin


pgsql-hackers by date:

Previous
From: Shane Ambler
Date:
Subject: Re: Syntax bug? Group by?
Next
From: "Mark Woodward"
Date:
Subject: Re: Syntax bug? Group by?