*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 <patrickbake...@gmail.com> wrote: > > > 2017-06-19 13:19 GMT+12:00 Melvin Davidson <melvin6...@gmail.com>: > >> >> >> On Sun, Jun 18, 2017 at 9:02 PM, Patrick B <patrickbake...@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 >> <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.