Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
2017-06-19 13:19 GMT+12:00 Melvin Davidson <melvin6925@gmail.com>:On Sun, Jun 18, 2017 at 9:02 PM, Patrick B <patrickbakerbr@gmail.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?ThanksPPerhaps you should read the doc.https://www.postgresql.org/docs/9.2/static/runtime-config-resource.html18.4.6. Asynchronous Behavior effective_io_concurrency (integer)I've done that! But I'm looking for some personal experiences and suggestions!!
On Sun, Jun 18, 2017 at 9:02 PM, Patrick B <patrickbakerbr@gmail.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?ThanksPPerhaps you should read the doc.https://www.postgresql.org/docs/9.2/static/runtime-config-resource.html18.4.6. Asynchronous Behavior effective_io_concurrency (integer)
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?ThanksP
В списке pgsql-general по дате отправления: