From: | Kenichiro Tanaka <ketanaka(at)ashisuto(dot)co(dot)jp> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: effective_io_concurrency details |
Date: | 2010-05-26 11:37:45 |
Message-ID: | 4BFD0809.4030202@ashisuto.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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_concurrency = 0,PostgreSQL never uses PREFETCH.
On my environment, my PostgreSQL doesn't start up when
effective_io_concurrency=1.
#My environment WinXP sp2 and PostgreSQL is 8.4.4, too.
What I referenced)
http://archives.postgresql.org/pgsql-hackers/2009-03/msg00911.php
http://doxygen.postgresql.org/bufmgr_8c-source.html#l00075
pgsql/src/backend/storage/buffer/bufmgr.c
00070 /*
00071 * How many buffers PrefetchBuffer callers should try to stay
ahead of their
00072 * ReadBuffer calls by. This is maintained by the assign hook for
00073 * effective_io_concurrency. Zero means "never prefetch".
00074 */
> 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
>
>
--
================================================
Kenichiro Tanaka
K.K.Ashisuto
http://www.ashisuto.co.jp/english/index.html
================================================
From | Date | Subject | |
---|---|---|---|
Next Message | paulo matadr | 2010-05-26 13:46:00 | Help on update. |
Previous Message | Cédric Villemain | 2010-05-26 11:05:52 | Re: effective_io_concurrency details |