From: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
---|---|
To: | Patrick B <patrickbakerbr(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: effective_io_concurrency increasing |
Date: | 2017-06-19 01:41:31 |
Message-ID: | CANu8FiyuC1FOJYwRRtXBFBb3dNhsgFu-sL5SWTA_0zNmZyRbSA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
*As per the docs:*
*1. This is dependent on whether or not you are using a RAID disk,2. "Some
experimentation may be needed to find the best value"*
*IOW, there is no general recommendation.*
On Sun, Jun 18, 2017 at 9:24 PM, Patrick B <patrickbakerbr(at)gmail(dot)com> wrote:
>
>
> 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!!
>
--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2017-06-19 02:09:24 | Re: effective_io_concurrency increasing |
Previous Message | Patrick B | 2017-06-19 01:24:51 | Re: effective_io_concurrency increasing |