Re: PostgreSQL Read IOPS limit per connection

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема Re: PostgreSQL Read IOPS limit per connection
Дата
Msg-id 20181228012900.GH30382@telsasoft.com
обсуждение исходный текст
Ответ на Re: PostgreSQL Read IOPS limit per connection  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: PostgreSQL Read IOPS limit per connection  (Merlin Moncure <mmoncure@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: PostgreSQL Read IOPS limit per connection
Следующее
От: Sebastiaan Mannem
Дата:
Сообщение: Re: psql cli tool and connection pooling