Re: Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment
Дата
Msg-id CAHyXU0zH+_UFTHd_o8kHkO3HSvdq6vMZURptGjmDdjZC6dA=cQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment  (domenico febbo <mimmopasticcio@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
On Mon, Nov 14, 2016 at 11:36 AM, domenico febbo
<mimmopasticcio@gmail.com> wrote:
> dear Pietro,
> are you sure about
>
> effective_io_concurrency = 30
>
> could you please explain the type of disk storage?

fast storage can certainly utilize high settings of
effective_io_concurrency at least in some cases...for example see:
https://www.postgresql.org/message-id/CAHyXU0yiVvfQAnR9cyH%3DHWh1WbLRsioe%3DmzRJTHwtr%3D2azsTdQ%40mail.gmail.com

merlin

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

Предыдущее
От: Pietro Pugni
Дата:
Сообщение: Re: Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment
Следующее
От: Seckin Pulatkan
Дата:
Сообщение: Re: Query planner chooses index scan backward instead of better index option