Re: Setting effective_io_concurrency in VM?

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Setting effective_io_concurrency in VM?
Дата
Msg-id 20171127235724.ec2ludkit57gdkoy@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: Setting effective_io_concurrency in VM?  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-performance
Hi,

On 2017-11-27 11:40:19 -0700, Scott Marlowe wrote:
> tl;dr: Only way to know is to benchmark it. I'd guess that somewhere
> between 10 and 20 is going to get the best throughput but that's just
> a guess. Benchmark it and let us know!

FWIW, for SSDs my previous experiments suggest that the sweet spot is
more likely to be an order of magnitude or two bigger. Depends a bit on
your workload (including size of scans and concurrency) obviously.

Greetings,

Andres Freund


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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Setting effective_io_concurrency in VM?
Следующее
От: Alex Reece
Дата:
Сообщение: Bad plan chosen for union all