Re: PostgreSQL Read IOPS limit per connection - Mailing list pgsql-performance

From Justin Pryzby
Subject Re: PostgreSQL Read IOPS limit per connection
Date
Msg-id 20181228012900.GH30382@telsasoft.com
Whole thread Raw
In response to Re: PostgreSQL Read IOPS limit per connection  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: PostgreSQL Read IOPS limit per connection
List pgsql-performance
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


pgsql-performance by date:

Previous
From: Jeff Janes
Date:
Subject: Re: PostgreSQL Read IOPS limit per connection
Next
From: Sebastiaan Mannem
Date:
Subject: Re: psql cli tool and connection pooling