Gregory Stark wrote:
> I could swear this has been discussed in the past too. I seem to recall Luke
> disparaging Postgres on the same basis but proposing an immensely complicated
> solution. posix_fadvise or using libaio in a simplistic fashion as a kind of
> fadvise would be fairly lightweight way to get most of the benefit of the more
> complex solutions.
It has been on the TODO list for a long time:
* Do async I/O for faster random read-ahead of data
Async I/O allows multiple I/O requests to be sent to the disk with
results coming back asynchronously.
I have added your thread URL to this.
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
+ If your life is a hard drive, Christ can be your backup. +
In response to
pgsql-hackers by date
|Next:||From: Simon Riggs||Date: 2007-12-12 08:34:09|
|Subject: Re: WORM and Read Only Tables (v0.1)|
|Previous:||From: Tom Lane||Date: 2007-12-12 05:30:50|
|Subject: Re: [firstname.lastname@example.org: Re: [pgsql-es-ayuda] SLL error 100% cpu] |