Postgres Pro
Downloads
Home   >   mailing lists

Effective IO Concurrency - Mailing list pgsql-general

From luis.roberto@siscobra.com.br
Subject Effective IO Concurrency
Date
Msg-id 347986270.6604014.1600090766280.JavaMail.zimbra@siscobra.com.br
Whole thread Raw
Responses Re: Effective IO Concurrency
List pgsql-general
Tree view
Hi!

In PostgreSQL 13, the way of using effective_io_concurrency has changed. Until v12, I used 200 for this value (using SSD drives). Using the new formula described in https://www.postgresql.org/docs/13/release-13.html gives me 1176. However, in the documentation https://www.postgresql.org/docs/13/runtime-config-resource.html#GUC-EFFECTIVE-IO-CONCURRENCY it says that the maximum value allowed is 1000.


pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Reg:CHARSET_COVERSION_LATIN_TO_UTF8
Next
From: Mike Noordermeer
Date:
Subject: Re: Dirty buffers with suppress_redundant_updates_trigger