Re: [GENERAL] effective_io_concurrency details

2010-05-26 Thread Kenichiro Tanaka
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

Re: [GENERAL] effective_io_concurrency details

2010-05-26 Thread Cédric Villemain
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

[GENERAL] effective_io_concurrency details

2010-05-26 Thread pasman pasmański
Hello. I have 2 questions: Is effective_io_concurrency working on WinXP sp2 ? and what is the difference between effective_io_concurrency = 0 and effective_io_concurrency = 1 Postgres 8.4.4 pasman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make change