From: Andres Freund <andres@anarazel.de>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Don Seiler <don@seiler.us>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: Setting effective_io_concurrency in VM?
Date: Mon, 27 Nov 2017 15:57:24 -0800
Message-ID: <20171127235724.ec2ludkit57gdkoy@alap3.anarazel.de> (raw)
In-Reply-To: <CAOR=d=1-W_Hqp8hmpcnCymW8=UpxdU1J8_nnsUmWA9RqhZw-gA@mail.gmail.com>
References: <CAHJZqBCAQYq46jdfNkJpaJ1SzeGnCjDnsMnGEod-_s7dEYGzow@mail.gmail.com>
<CAOR=d=1-W_Hqp8hmpcnCymW8=UpxdU1J8_nnsUmWA9RqhZw-gA@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: andres@anarazel.de, scott.marlowe@gmail.com, don@seiler.us, pgsql-performance@lists.postgresql.org
Subject: Re: Setting effective_io_concurrency in VM?
In-Reply-To: <20171127235724.ec2ludkit57gdkoy@alap3.anarazel.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox