Re: ice-broker scan thread
От | David Boreham |
---|---|
Тема | Re: ice-broker scan thread |
Дата | |
Msg-id | 438BE53B.1090106@boreham.org обсуждение исходный текст |
Ответ на | Re: ice-broker scan thread (Qingqing Zhou <zhouqq@cs.toronto.edu>) |
Список | pgsql-hackers |
Qingqing Zhou wrote: <blockquote cite="midPine.LNX.4.58.0511282350370.13833@josh.db" type="cite"><pre wrap=""> On Mon, 28 Nov 2005, Gavin Sherry wrote: </pre><blockquote type="cite"><pre wrap="">MySQL, Oracle and others implement read-aheadthreads to simulate async IO 'pre-fetching'. </pre></blockquote><pre wrap=""> Due to my tests on Windows (using the attached program and change enable_aio=true), seems aio doesn't help as a separate thread - but maybe because my usage is wrong ... </pre></blockquote> I don't think your NT overlapped I/O code is quite right. At least<br />I think it will issue reads at a high rate without waiting for any of them<br /> to complete. Beyond some point that hasto give the kernel gut-rot.<br /> But anyway, I wouldn't expect the use of aio to make any<br /> significant differencein an already threaded test program. <br /> The point of aio is to allow<br /> I/O concurrency _without_ the useof threads or multiple processes.<br /> You could re-write your program to have a single thread but use aio.<br /> Inthat case it should show the same read ahead benefit that you see<br /> with the thread.<br /><br /><br /><br />
В списке pgsql-hackers по дате отправления: