[GENERAL] effective_io_concurrency increasing

Поиск
Список
Период
Сортировка
От Patrick B
Тема [GENERAL] effective_io_concurrency increasing
Дата
Msg-id CAJNY3itnExSrh3twQ7Un1q+iZ02ketQnu7Axp2TT56eycuF5Dw@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] effective_io_concurrency increasing  (Melvin Davidson <melvin6925@gmail.com>)
Re: [GENERAL] effective_io_concurrency increasing  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: [GENERAL] effective_io_concurrency increasing  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Список pgsql-general
Дерево обсуждения
Hi guys.

I just wanna understand the effective_io_concurrency value better.

My current Master database server has 16 vCPUS and I use effective_io_concurrency = 0.

What can be the benefits of increasing that number? Also, do you guys have any recommendations? 

I'm using PG 9.2 and the official doc does not say much about which value you should use.

If I put it to 1, does it mean I can have a query spread into 1 processor?

Thanks
P

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] storing postgres data on dropbox
Следующее
От: Melvin Davidson
Дата:
Сообщение: Re: [GENERAL] effective_io_concurrency increasing