Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id A6103119C298 for ; Thu, 8 Mar 2012 12:18:45 -0400 (AST) Received: from smtp2.peak6.com ([38.98.137.9]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S5g3A-0004zv-0k for pgsql-performance@postgresql.org; Thu, 08 Mar 2012 16:18:44 +0000 X-AuditID: 0a02cb1e-b7bceae0000009d3-10-4f58dbdcf0d9 Message-ID: <4F58DBD6.4080108@peak6.com> Date: Thu, 8 Mar 2012 10:18:30 -0600 From: Shaun Thomas Reply-To: Organization: Peak6 User-Agent: Mozilla/5.0 (X11; Linux i686; rv:10.0.2) Gecko/20120216 Thunderbird/10.0.2 MIME-Version: 1.0 To: Jochen Erwied CC: Subject: Re: Advice sought : new database server References: <20120304095838.GA3064@campbell-lange.net> <20120304183630.GA8902@campbell-lange.net> <4F57E019.8050002@peak6.com> <417510800.20120308171558@erwied.eu> In-Reply-To: <417510800.20120308171558@erwied.eu> Content-Type: text/plain; charset="ISO-8859-1"; format=flowed content-transfer-encoding: 7bit X-Originating-IP: [10.10.107.46] X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFrrHIsWRmVeSWpSXmKPExsXCxcQroXv3doS/weLHbBbzb/QzW1yfeY7Z gcnj1PGL7B4X9k1jD2CKamC0SczLyy9JLElVSEktTrZVCnB19DZTcMksTs5JzMxNLVJSyEyx VTJTUijISUxOzU3NK7FVSiwoSM1LUbLjUsAANkBlmXkKqXnJ+SmZeem2Sp7B/roWFqaWuoZK dvFYQEITS8bdK79ZC54zV6zY95GxgbGZuYuRk0NCwERizen5LBC2mMSFe+vZQGxeAQ2JrTee g9WwCKhItE5qZASx2QTUJBbuvglmCwnISuxfdY4VxOYXEJbY96EJqJ6DQ1QgTGLBO0+IMYIS J2c+ARsvImAm8eT+S7DxzEBj5j6cBNYqLGAl0fG3gb2LkQto5HZmibM/b7KCzOEUMJS49iYO ot5W4sKc6ywQtrzE9rdzmCFOkJO40/CcDeJ8BYk5V9tZJjAKzUKyehaS9llI2hcwMq9iFC8u S0zOyDQrKM4tKTDUK0hNzDbTy0st2cQIjtvTcjsYV1xQPMQowMGoxMObcCvcX4g1say4MvcQ owQHs5IIb3dHhL8Qb0piZVVqUX58UWlOavEhRlNgkE1klhJNzgemlLySeENjQ0tTS2MzAyMT Swslcd5DbwP8hQTSgakhOzW1ILUIpo+Jg1OqgVFHYs8PmcSsEw/3HHwxqfW7i7E1k3O5xSJx Q25tvuX3NRzlTvBHb/jyQGpVyzP5+7e11z7ebtAnsv3G0mO2KiISF/R4sqcuVX765qjVx1KO r4U+ETcMv9txr+jM4GZ4Vn1xdXoF3zTb10/2zDmYxWzmf2lf07+/k1a8dAps90nm3Dyj+YHT JE4lluKMREMt5qLiRAAzRiyc8QIAAA== X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/82 X-Sequence-Number: 46532 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