Re: Setting effective_io_concurrency in VM?

From: Andres Freund <andres(at)anarazel(dot)de>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Don Seiler <don(at)seiler(dot)us>, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Setting effective_io_concurrency in VM?
Date: 2017-11-27 23:57:24
Message-ID: 20171127235724.ec2ludkit57gdkoy@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Alex Reece 2017-11-28 10:13:38 Bad plan chosen for union all
Previous Message Jeff Janes 2017-11-27 23:18:58 Re: Setting effective_io_concurrency in VM?