Re: [GENERAL] effective_io_concurrency increasing

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: [GENERAL] effective_io_concurrency increasing
Дата
Msg-id CAHyXU0xP4LK9TcsNhc-2wtNXZtt2pELKxOFusN7KKGkQ=5WQ8g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] effective_io_concurrency increasing  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: [GENERAL] effective_io_concurrency increasing
Re: [GENERAL] effective_io_concurrency increasing
Список pgsql-general
On Mon, Jun 19, 2017 at 10:36 AM, Jeff Janes <jeff.janes@gmail.com> wrote:
> If you have a RAID, set it to the number of spindles in your RAID and forget
> it. It is usually one of the less interesting knobs to play with.  (Unless
> your usage pattern of the database is unusual and exact fits the above
> pattern.)

Isn't that advice obsolete in a SSD world though?  I was able to show
values up to 256 for a single device provided measurable gains for a
single S3500.  It's true though that the class of queries that this
would help is pretty narrow.

merlin


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

Предыдущее
От: Paul Jungwirth
Дата:
Сообщение: Re: [GENERAL] Postgres Data Encryption Using LUKS with dm-crypt ?
Следующее
От: Igor Korot
Дата:
Сообщение: [GENERAL] Remote connection to PostgreSQL