Re: hint in determining effective_io_concurrency

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: hint in determining effective_io_concurrency
Дата
Msg-id 20210422195232.GA25061@momjian.us
обсуждение исходный текст
Ответ на hint in determining effective_io_concurrency  (Luca Ferrari <fluca1978@gmail.com>)
Ответы Re: hint in determining effective_io_concurrency
Re: hint in determining effective_io_concurrency
Список pgsql-performance
On Thu, Apr 22, 2021 at 09:45:15PM +0200, Luca Ferrari wrote:
> Hi all,
> I'm unable to find (apparently) a way to find out a possible value to
> start with for effective_io_concurrency.
> I suspect that benchmarking, e.g., using bonnie++ or sysbench and
> testing with different values of concurrency could help to determine
> the max number of concurrent request, (tps, lower latency, ecc.).
> Is thjs correct or is there another suggested way?

I recommend 256 for SSDs or other RAM-like fsync systems, and maybe
maybe 16 for magnetic.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.




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

Предыдущее
От: Luca Ferrari
Дата:
Сообщение: hint in determining effective_io_concurrency
Следующее
От: Luca Ferrari
Дата:
Сообщение: Re: hint in determining effective_io_concurrency