Re: effective_io_concurrency and NVMe devices

Поиск
Список
Период
Сортировка
От Nathan Bossart
Тема Re: effective_io_concurrency and NVMe devices
Дата
Msg-id 20220420175858.GA2634425@nathanxps13
обсуждение исходный текст
Ответ на effective_io_concurrency and NVMe devices  (Bruce Momjian <bruce@momjian.us>)
Ответы RE: effective_io_concurrency and NVMe devices  (Jakub Wartak <Jakub.Wartak@tomtom.com>)
Список pgsql-hackers
On Tue, Apr 19, 2022 at 10:56:05PM -0400, Bruce Momjian wrote:
> NVMe devices have a maximum queue length of 64k:
> 
>     https://blog.westerndigital.com/nvme-queues-explained/
> 
> but our effective_io_concurrency maximum is 1,000:
> 
>     test=> set effective_io_concurrency = 1001;
>     ERROR:  1001 is outside the valid range for parameter "effective_io_concurrency" (0 .. 1000)
> 
> Should we increase its maximum to 64k?  Backpatched?  (SATA has a
> maximum queue length of 256.)

If there are demonstrable improvements with higher values, this seems
reasonable to me.  I would even suggest removing the limit completely so
this doesn't need to be revisited in the future.

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com



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

Предыдущее
От: Nathan Bossart
Дата:
Сообщение: Re: [Proposal] vacuumdb --schema only
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: Bad estimate with partial index