Re: Effective IO Concurrency

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: luis(dot)roberto(at)siscobra(dot)com(dot)br, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Effective IO Concurrency
Date: 2020-09-14 16:03:22
Message-ID: f0f848f7e740481799440fe1453985edfd78fd32.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 2020-09-14 at 10:39 -0300, luis(dot)roberto(at)siscobra(dot)com(dot)br wrote:
> 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.

Then use the value 1000...

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2020-09-14 16:10:23 Re: Effective IO Concurrency
Previous Message Michael Lewis 2020-09-14 15:35:40 Re: Dirty buffers with suppress_redundant_updates_trigger