Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gcgxZ-0008FS-1c for pgsql-performance@arkaria.postgresql.org; Fri, 28 Dec 2018 01:29:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gcgxX-00063D-K2 for pgsql-performance@arkaria.postgresql.org; Fri, 28 Dec 2018 01:29:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gcgxX-00062F-43 for pgsql-performance@lists.postgresql.org; Fri, 28 Dec 2018 01:29:07 +0000 Received: from mail-io1-xd41.google.com ([2607:f8b0:4864:20::d41]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gcgxT-0004Tt-Ds for pgsql-performance@postgresql.org; Fri, 28 Dec 2018 01:29:05 +0000 Received: by mail-io1-xd41.google.com with SMTP id x6so15778972ioa.9 for ; Thu, 27 Dec 2018 17:29:03 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=S+2Bvp/jUCG97pmWtyyaHrHbR64pHyCe9KAyobCqL7c=; b=pQV/RmoJ8GEIEG0hyhysbqr05KkzcN39jJ1hjaTD2zMQ/wseP4yP913cVOKiOM5kOa oFa0F0Ef0fFYeoLGQ81svykAOQaCAjtaIfE8uWDFIj7sxn8ltlrsgfC5Fb1UYYgI6hnd vZdyzGC4duExTm/2vJS30Ob2vgDu067g5TrE1O1M100Tw+6U+Hzq4Ehjeyo4kdLtRnfn QiYFppL77h/0B6sE9T1pFo6lzZTfybah7aTHAJQJdzRd4Ar6QP+dyMEFcCNklvkWGyWL RB9gIYy4DPvDky/wNlmLLHr8hnOG6AF/4mXTUzJY7c4IVWIUXKSZfuWvQ+/uVeHVkY81 nLmA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=S+2Bvp/jUCG97pmWtyyaHrHbR64pHyCe9KAyobCqL7c=; b=l6vA1MSow/Hx8NV0hQU2rMCc12Hz7OfrnhgYdg+Bs6hzuu3LNvCK9OotEIz23K1xUE IotcL7SpiQoREj19cPpRdntiemGhvnz++9/IiLJ4uueeTVrvv/A96s3H3PyZjB8blDku q30QH/ijiYIvj6F0AS9KUS9VvzS+7fT1pXTH50V75srSVTQN+IJ8gAOvW0soQ0oJFHKp MZJtDZcIe8lcD316ze7z0YcB01vNBhhgOZdgcO+IUBGD07jrA8RFOHsaIX1w6yI5v4bC mWUfCdZ0HgX4kkspYbBDrstSOzC1tI7urRUabzZSD8YDPAZmgAe08/zmuB90LiIzD+dS XSdg== X-Gm-Message-State: AJcUukdVtR9KjmXBVR3jMsFvIWNoO1i9uIkTN8/qHwpgxTgOJnJVXaDJ PPompMTU0cG5aX1CjtQZfbbYfQ== X-Google-Smtp-Source: ALg8bN5dy0GednJWhwt8wzknOql7SELLcK9N5gyhnHBS9dAB2xhmXkpi6oIJVKELipI1E9H4TslIIg== X-Received: by 2002:a6b:c8c9:: with SMTP id y192mr16791391iof.183.1545960542088; Thu, 27 Dec 2018 17:29:02 -0800 (PST) Received: from pryzbyj (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id o192sm6471624itb.31.2018.12.27.17.29.01 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 27 Dec 2018 17:29:01 -0800 (PST) Received: by pryzbyj (Postfix, from userid 1000) id 7AD8F8054BB; Thu, 27 Dec 2018 19:29:00 -0600 (CST) Date: Thu, 27 Dec 2018 19:29:00 -0600 From: Justin Pryzby To: Jeff Janes Cc: pgsql-performance@postgresql.org Subject: Re: PostgreSQL Read IOPS limit per connection Message-ID: <20181228012900.GH30382@telsasoft.com> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.23 (2014-03-12) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Thu, Dec 27, 2018 at 08:20:23PM -0500, Jeff Janes wrote: > Also, you would want to use the newest version of PostgreSQL, as 9.6 > doesn't have parallel query, which is much more generally applicable than > effective_io_concurrency is. It *does* have parallel query (early, somewhat limited support), but not enabled by default. https://www.postgresql.org/docs/9.6/parallel-query.html There was some confusion due to being disabled in 9.6, only: https://www.postgresql.org/message-id/20180620151349.GB7500%40momjian.us Cheers, Justin