Re: PostgreSQL Read IOPS limit per connection

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL Read IOPS limit per connection
Date: 2018-12-28 01:29:00
Message-ID: 20181228012900.GH30382@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Sebastiaan Mannem 2018-12-28 09:04:16 Re: psql cli tool and connection pooling
Previous Message Jeff Janes 2018-12-28 01:20:23 Re: PostgreSQL Read IOPS limit per connection