Re: Advice/guideline on increasing shared_buffers and kernel parameters

Поиск
Список
Период
Сортировка
От Gnanakumar
Тема Re: Advice/guideline on increasing shared_buffers and kernel parameters
Дата
Msg-id 005e01cd2e87$81d58850$858098f0$@com
обсуждение исходный текст
Ответ на Re: Advice/guideline on increasing shared_buffers and kernel parameters  ("Gnanakumar" <gnanam@zoniac.com>)
Список pgsql-admin
> A formula which has held up pretty well across a lot of benchmarks
> for years is that for optimal throughput the number of active
> connections should be somewhere near
> ((core_count * 2) + effective_spindle_count).

Our entire Production application stack is setup in Amazon EC2 cloud
environment, that includes database server also.  So, in that case, how do I
find out "effective_spindle_count"?  I know "core_count" can be determined
from Amazon EC2 instance type.  Per Amazon EC2, EBS volumes are reportedly a
shared resource.



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

Предыдущее
От: "Gnanakumar"
Дата:
Сообщение: Re: Advice/guideline on increasing shared_buffers and kernel parameters
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Advice/guideline on increasing shared_buffers and kernel parameters