Re: [GENERAL] effective_io_concurrency increasing

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [GENERAL] effective_io_concurrency increasing
Дата
Msg-id CAKFQuwaT6PcxBw54PSzu4BuaQgwjmLG6Zj_G+GDCoJDfmD_fPQ@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] effective_io_concurrency increasing  (Patrick B <patrickbakerbr@gmail.com>)
Ответы Re: [GENERAL] effective_io_concurrency increasing
Список pgsql-general
On Sun, Jun 18, 2017 at 6: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.

​It seems as though the number of virtual CPUs little to no bearing on whether, or to what value, you should set this parameter.  Obviously with only one CPU parallelism wouldn't be possible (I'm assuming a single query does not make multiple parallel requests for data) but the value seems to strictly describe a characteristic the I/O subsystem.  Whether you can fully leverage a properly set large value is another matter.

​As general advice, even you are using a soon to be obsolete (or any non-current really) version of PostgreSQL when you are learning about a new concept checking the most recent docs can be helpful.  Generally only bugs in the docs get back-patched but a number of doc contributions are not bug related but helpful none-the-less.


​In short, if you want any good advice you will need to figure out the specifics of your I/O subsystem (non-volatile memory and any associated hardware), and share that with the list.​ Lacking rules-of-thumb learning how to test your system and measure changes would help get you to the end goal.  Sadly not a skill I've really picked up as of yet.

​David J.​

В списке pgsql-general по дате отправления:

Предыдущее
От: Melvin Davidson
Дата:
Сообщение: Re: [GENERAL] effective_io_concurrency increasing
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: [GENERAL] effective_io_concurrency increasing