Re: Effective IO Concurrency

Поиск
Список
Период
Сортировка
От Ron
Тема Re: Effective IO Concurrency
Дата
Msg-id 4637f0e5-d3fa-2ff3-64e8-3835ec67e67c@gmail.com
обсуждение исходный текст
Ответ на Re: Effective IO Concurrency  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: Effective IO Concurrency  (luis.roberto@siscobra.com.br)
Список pgsql-general
On 9/14/20 11:03 AM, Laurenz Albe wrote:
> On Mon, 2020-09-14 at 10:39 -0300, luis.roberto@siscobra.com.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...

I think he means that the formula should take that into account.

-- 
Angular momentum makes the world go 'round.



В списке pgsql-general по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Effective IO Concurrency
Следующее
От: Mike Noordermeer
Дата:
Сообщение: Re: Dirty buffers with suppress_redundant_updates_trigger