Re: effective_io_concurrency increasing

2017-06-19 13:19 GMT+12:00 Melvin Davidson <melvin6925(at)gmail(dot)com>:

>
>
> On Sun, Jun 18, 2017 at 9:02 PM, Patrick B <patrickbakerbr(at)gmail(dot)com>
> wrote:
>
>> Hi guys.
>>
>> I just wanna understand the effective_io_concurrency value better.
>>
>> My current Master database server has 16 vCPUS and I
>> use effective_io_concurrency = 0.
>>
>> What can be the benefits of increasing that number? Also, do you guys
>> have any recommendations?
>>
>> I'm using PG 9.2 and the official doc does not say much about which value
>> you should use.
>>
>> If I put it to 1, does it mean I can have a query spread into 1 processor?
>>
>> Thanks
>> P
>>
>
>
>
> *Perhaps you should read the
> doc.https://www.postgresql.org/docs/9.2/static/runtime-config-resource.html
> <https://www.postgresql.org/docs/9.2/static/runtime-config-resource.html>*
> 18.4.6. Asynchronous Behavior *effective_io_concurrency (integer)*
>

I've done that! But I'm looking for some personal experiences and
suggestions!!