Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aY4EZ-0004RJ-RW for pgsql-admin@arkaria.postgresql.org; Tue, 23 Feb 2016 04:05:59 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aY4EZ-0002eL-Cy for pgsql-admin@arkaria.postgresql.org; Tue, 23 Feb 2016 04:05:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aY4EX-0002e4-PF for pgsql-admin@postgresql.org; Tue, 23 Feb 2016 04:05:57 +0000 Received: from www.commandprompt.com ([2604:da00:2:2:5054:ff:fe07:7618] helo=lists.commandprompt.com) by magus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1aY4EO-0002ey-4a for pgsql-admin@postgresql.org; Tue, 23 Feb 2016 04:05:55 +0000 Received: from [192.168.1.5] (spinlock.commandprompt.com [69.168.55.30]) by lists.commandprompt.com (Postfix) with ESMTPA id 8F43A62A; Mon, 22 Feb 2016 20:05:43 -0800 (PST) Received: from c-67-168-169-165.hsd1.wa.comcast.net ([67.168.169.165] helo=[192.168.1.5]) by assp.commandprompt.com with SMTPSA(TLSv1_2 ECDHE-RSA-AES128-GCM-SHA256) (2.4.5); 22 Feb 2016 20:05:43 -0800 Subject: Re: [TIPS] Tuning PostgreSQL 9.2 To: Scott Marlowe , "drum.lucas@gmail.com" References: Cc: Payal Singh , Scott Whitney , "pgsql-admin@postgresql.org" From: "Joshua D. Drake" Organization: Command Prompt, Inc. Message-ID: <56CBDA97.2090403@commandprompt.com> Date: Mon, 22 Feb 2016 20:05:43 -0800 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.5.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Assp-Version: 2.4.5(15162) on assp.commandprompt.com X-Assp-ID: assp.commandprompt.com m1-00343-09092 X-Assp-Session: 7F2B874B9FD0 (mail 1) X-Assp-Envelope-From: jd@commandprompt.com X-Assp-Intended-For: pgsql-admin@postgresql.org X-Assp-Intended-For: scott@journyx.com X-Assp-Intended-For: payal@omniti.com X-Assp-Intended-For: drum.lucas@gmail.com X-Assp-Intended-For: scott.marlowe@gmail.com X-Assp-Original-Subject: Re: [ADMIN] [TIPS] Tuning PostgreSQL 9.2 X-Assp-Client-SSL: yes X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On 02/22/2016 07:41 PM, Scott Marlowe wrote: >> I'm running a CentOS 6.6 with Kernel 2.6.32-504.el6 >> >> Is it possible to upgrade to the 3.13 version using Centos 6.6? (I think >> only in Centos 7) >> Is so, can you please provide me any link that shows a IO improvement >> between two kernels? something that I can study > > It has been many years since I took care of a Centos box, but in this > article by Josh Berkus about avoiding kernel 3.2 it is mentioned that > centos 7 can in fact run 3.10 kernel. > > http://www.databasesoup.com/2014/09/why-you-need-to-avoid-linux-kernel-32.html It isn't just 3.2. You should avoid 3.2-3.8. 2.6 is fine. JD > > -- Command Prompt, Inc. http://the.postgres.company/ +1-503-667-4564 PostgreSQL Centered full stack support, consulting and development. Everyone appreciates your honesty, until you are honest with them. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin