Hello.
>Is effective_io_concurrency working on WinXP sp2 ?
No.
"effective_io_concurrency" works when an OS can use posix_fadvise().
But I think WinXP doesn't have posix_fadvise().
>and what is the difference between effective_io_concurrency = 0
>and effective_io_concurrency = 1
If effective_io
2010/5/26 pasman pasmański :
> Hello.
>
> I have 2 questions:
> Is effective_io_concurrency working on WinXP sp2 ?
no
> and what is the difference between effective_io_concurrency = 0
> and effective_io_concurrency = 1
0 disable prefetching.
1 allow a short prefetch window
>
>
> Postgres 8.4.4
