Horton
Menu

Re: Asynchronous I/O Support

Merlin Moncure <mmoncure@gmail.com>

View thread
From: "Merlin Moncure" <mmoncure@gmail.com>
To: "Luke Lonergan" <llonergan@greenplum.com>
Cc: "Martijn van Oosterhout" <kleptog@svana.org>, "Raja Agrawal" <raja.agrawal@gmail.com>, pgsql-hackers@postgresql.org
Date: 2006-10-17T17:18:19Z
Lists: 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