> > So far I've seen no evidence that async I/O would help us, only a lot > > of wishful thinking. > > is this thread moot? while researching this thread I came across this > article: http://kerneltrap.org/node/6642 describing claims of > 30% performance boost when using posix_fadvise to ask the o/s > to prefetch data. istm that this kind of improvement is in > line with what aio can provide, and posix_fadvise is cleaner, > not requiring threads and such.
This again is for better OS readahead for sequential access, where standard Linux obviously behaves differently. It is not about random access. Btw. I do understand the opinion from Linux developers, that pg should actually read larger blocks for seq scans. In cases of high disk load OS's tend to not do all needed readahead, which has pros and cons, but mainly cons for pg. Andreas ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend