| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com> |
| Cc: | Payal Singh <payal(at)omniti(dot)com>, Scott Whitney <scott(at)journyx(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: [TIPS] Tuning PostgreSQL 9.2 |
| Date: | 2016-02-23 03:41:38 |
| Message-ID: | CAOR=d=2UQHzfhYW3n0qg=iNkuTACkMaWyXj0r=gFcU0A2zY+eQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, Feb 22, 2016 at 2:23 PM, drum(dot)lucas(at)gmail(dot)com
<drum(dot)lucas(at)gmail(dot)com> wrote:
>
>
> On 22 February 2016 at 07:34, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
>>
>> I also noticed you're running RHEL 6.x which runs on the truly ancient
>> (but pretty reliable) 2.6.32 kernel. The newer 3.11 and 3.13 kernels
>> are MUCH faster at IO and a lot smarter about caching and when to swap
>> etc. I've seen several big machines go from a few thousand tps to 15
>> to 20k tps just from going from 3.2 to 3.13. Keep us updated on
>> whether or not a pooler works for you.
>
>
>
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2016-02-23 04:05:43 | Re: [TIPS] Tuning PostgreSQL 9.2 |
| Previous Message | David G. Johnston | 2016-02-22 22:20:08 | Re: Extracting JSON data into columns |