Re: Advice sought : new database server

Поиск
Список
Период
Сортировка
Искать
От
Shaun Thomas
Тема
Re: Advice sought : new database server
Дата
Msg-id
4F58DBD6.4080108@peak6.com
Ответ на
Re: Advice sought : new database server (Jochen Erwied)
Список
Дерево обсуждения
Advice sought : new database server Rory Campbell-Lange <rory@campbell-lange.net>
Re: Advice sought : new database server Rory Campbell-Lange <rory@campbell-lange.net>
Re: Advice sought : new database server Michael Friedl <linux@nicce.at>
Re: Advice sought : new database server Steve Crawford <scrawford@pinpointresearch.com>
Re: Advice sought : new database server Andy Colson <andy@squeakycode.net>
Re: Advice sought : new database server Scott Marlowe <scott.marlowe@gmail.com>
Re: Advice sought : new database server Scott Marlowe <scott.marlowe@gmail.com>
Re: Advice sought : new database server Rory Campbell-Lange <rory@campbell-lange.net>
Re: Advice sought : new database server Craig James <cjames@emolecules.com>
Re: Advice sought : new database server Rory Campbell-Lange <rory@campbell-lange.net>
Re: Advice sought : new database server Merlin Moncure <mmoncure@gmail.com>
Re: Advice sought : new database server Ants Aasma <ants.aasma@eesti.ee>
Re: Advice sought : new database server Rory Campbell-Lange <rory@campbell-lange.net>
Re: Advice sought : new database server Jeff Janes <jeff.janes@gmail.com>
Re: Advice sought : new database server Craig James <cjames@emolecules.com>
Re: Advice sought : new database server Shaun Thomas <sthomas@peak6.com>
Re: Advice sought : new database server Jochen Erwied <jochen@pgsql-performance.erwied.eu>
Re: Advice sought : new database server Shaun Thomas <sthomas@peak6.com>
Re: Advice sought : new database server Scott Marlowe <scott.marlowe@gmail.com>
Re: Advice sought : new database server Scott Marlowe <scott.marlowe@gmail.com>
Re: Advice sought : new database server Rory Campbell-Lange <rory@campbell-lange.net> 
On 03/08/2012 10:15 AM, Jochen Erwied wrote:

> Shouldn't that be:
>
> kernel.shmmax = 4294967296
> kernel.shmmni = 4096
> kernel.shmall = 1572864

Oops! Yes. That's definitely it. I'm too accustomed to having those set 
automatically, and then setting these:

vm.swappiness = 0
vm.dirty_background_ratio = 1
vm.dirty_ratio = 10

Sorry about that!

-- 
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-444-8534
sthomas@peak6.com

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
В списке pgsql-performance по дате отправления
Предыдущее
От: Jochen Erwied
Дата:
Следующее
От: Rory Campbell-Lange
Дата:
FAQ