| From: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: effective_io_concurrency increasing |
| Date: | 2017-06-19 07:29:44 |
| Message-ID: | 046caa9b-9ed5-f905-6cdf-6d67c77eafa2@a-kretschmer.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Am 19.06.2017 um 03:02 schrieb Patrick B:
> 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?
>
>
as far as i know, at the moment only bitmap-index-scans would benefit
from higher values. You can try 16 or 32 as starting point.
(if you have a proper io-controller with cache)
(it has nothing to do with parallel execution of queries)
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2017-06-19 07:40:52 | Re: Postgres Data Encryption Using LUKS with dm-crypt ? |
| Previous Message | David G. Johnston | 2017-06-19 02:09:24 | Re: effective_io_concurrency increasing |