| From: | James Robinson <james(at)jlr-photo(dot)com> |
|---|---|
| To: | Sergei Kornilov <sk(at)zsrv(dot)org> |
| Cc: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #15396: initdb emits wrong comment for range for effective_io_concurrency |
| Date: | 2018-09-23 18:33:53 |
| Message-ID: | FC4EF41B-8D7D-44AD-87B3-B6A8FFAB0885@jlr-photo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
> On Sep 23, 2018, at 2:27 PM, Sergei Kornilov <sk(at)zsrv(dot)org> wrote:
>
> Hello
>
> effective_io_concurrency can not be set is your system does not support USE_POSIX_FADVISE. In this case only allowed value for effective_io_concurrency is zero.
> As far i know mac os does not support posix_fadvise.
>
> Also this is documented behavior https://www.postgresql.org/docs/11/static/runtime-config-resource.html
>> Asynchronous I/O depends on an effective posix_fadvise function, which some operating systems lack. If the function is not present then setting this parameter to anything but zero will result in an error.
>
> regards, Sergei
Thanks Sergei,
Possibilities of augmenting either the initdb template comments according to if USE_POSIX_FADVISE or not, or perhaps the runtime error (probably harder).
In any event, I agree not a PG11 beta issue. Perhaps I'll craft a pithy patch against HEAD sometime in the future.
James
-----
James Robinson
james(at)jlr-photo(dot)com
http://jlr-photo.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2018-09-23 20:06:43 | Re: BUG #15395: Assert failure when using CURRENT OF with inheritance |
| Previous Message | Sergei Kornilov | 2018-09-23 18:27:10 | Re: BUG #15396: initdb emits wrong comment for range for effective_io_concurrency |