Re: [GENERAL] effective_io_concurrency increasing

Поиск
Список
Период
Сортировка
Искать
От
Andreas Kretschmer
Тема
Re: [GENERAL] effective_io_concurrency increasing
Дата
Msg-id
046caa9b-9ed5-f905-6cdf-6d67c77eafa2@a-kretschmer.de
Ответ на
[GENERAL] effective_io_concurrency increasing (Patrick B)
Список
Дерево обсуждения
[GENERAL] effective_io_concurrency increasing Patrick B <patrickbakerbr@gmail.com>
Re: [GENERAL] effective_io_concurrency increasing Andreas Kretschmer <andreas@a-kretschmer.de>
Re: [GENERAL] effective_io_concurrency increasing "David G. Johnston" <david.g.johnston@gmail.com>
Re: [GENERAL] effective_io_concurrency increasing Jeff Janes <jeff.janes@gmail.com>
Re: [GENERAL] effective_io_concurrency increasing Peter Geoghegan <pg@bowt.ie>
Re: [GENERAL] effective_io_concurrency increasing Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [GENERAL] effective_io_concurrency increasing Peter Geoghegan <pg@bowt.ie>
Re: [GENERAL] effective_io_concurrency increasing Andres Freund <andres@anarazel.de>
Re: [GENERAL] effective_io_concurrency increasing Peter Geoghegan <pg@bowt.ie>
Re: [GENERAL] effective_io_concurrency increasing Peter Geoghegan <pg@bowt.ie>
Re: [GENERAL] effective_io_concurrency increasing Merlin Moncure <mmoncure@gmail.com>
Re: [GENERAL] effective_io_concurrency increasing Bruce Momjian <bruce@momjian.us>
Re: [GENERAL] effective_io_concurrency increasing Jeff Janes <jeff.janes@gmail.com>
Re: [GENERAL] effective_io_concurrency increasing Melvin Davidson <melvin6925@gmail.com>
Re: [GENERAL] effective_io_concurrency increasing Patrick B <patrickbakerbr@gmail.com>
Re: [GENERAL] effective_io_concurrency increasing Melvin Davidson <melvin6925@gmail.com> 


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
В списке pgsql-general по дате отправления
Предыдущее
От: David G. Johnston
Дата:
Следующее
От: Scott Marlowe
Дата:
FAQ