Effective IO Concurrency

From: luis(dot)roberto(at)siscobra(dot)com(dot)br
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Effective IO Concurrency
Date: 2020-09-14 13:39:26
Message-ID: 347986270.6604014.1600090766280.JavaMail.zimbra@siscobra.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 | 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 | https://www.postgresql.org/docs/13/runtime-config-resource.html#GUC-EFFECTIVE-IO-CONCURRENCY ] it says that the maximum value allowed is 1000.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Noordermeer 2020-09-14 15:12:16 Re: Dirty buffers with suppress_redundant_updates_trigger
Previous Message Magnus Hagander 2020-09-14 08:08:27 Re: Reg:CHARSET_COVERSION_LATIN_TO_UTF8