Re: Setting effective_io_concurrency in VM? - Mailing list pgsql-performance

From Andres Freund
Subject Re: Setting effective_io_concurrency in VM?
Date
Msg-id 20171127235724.ec2ludkit57gdkoy@alap3.anarazel.de
Whole thread Raw
In response to Re: Setting effective_io_concurrency in VM?  (Scott Marlowe <scott.marlowe@gmail.com>)
List 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 by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Setting effective_io_concurrency in VM?
Next
From: Alex Reece
Date:
Subject: Bad plan chosen for union all