Re: tuning postgresql 9.3.5 and multiple cores

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: tuning postgresql 9.3.5 and multiple cores
Дата
Msg-id CAMkU=1y=r2XkUhiyZc4h2V1iTdR_H60XywHDmUUt2uYVQa8uew@mail.gmail.com
обсуждение исходный текст
Ответ на tuning postgresql 9.3.5 and multiple cores  (Jeison Bedoya Delgado <jeisonb@audifarma.com.co>)
Ответы Re: tuning postgresql 9.3.5 and multiple cores  (Soni M <diptatapa@gmail.com>)
Список pgsql-performance
Дерево обсуждения
On Monday, August 25, 2014, Jeison Bedoya Delgado <jeisonb@audifarma.com.co> wrote:
hi, recently i change the hardware of my database 32 cores up to 64 cores and 128GB Ram, but the performance is the same.  Perhaps i have to change any parameter in the postgresql.conf?.


PostgreSQL does not (yet) automatically parallelize queries.

Unless you have more than 32 queries trying to run at the same time, increasing the number of cores from 32 to 64 is unlikely to be useful.

Cheers,

Jeff

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3
Следующее
От: Mark Kirkwood
Дата:
Сообщение: Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3