Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] effective_io_concurrency increasing - Mailing list pgsql-general

From Melvin Davidson
Subject Re: [GENERAL] effective_io_concurrency increasing
Date
Msg-id CANu8FiyuC1FOJYwRRtXBFBb3dNhsgFu-sL5SWTA_0zNmZyRbSA@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] effective_io_concurrency increasing  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-general
Tree view
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@gmail.com> wrote:


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?

Thanks
P

Perhaps you should read the doc.
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.

pgsql-general by date:

Previous
From: Patrick B
Date:
Subject: Re: [GENERAL] effective_io_concurrency increasing
Next
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] effective_io_concurrency increasing