Re: [TIPS] Tuning PostgreSQL 9.2

From: "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com>
To: Scott Marlowe <scott(dot)marlowe(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-22 21:23:05
Message-ID: CAE_gQfWU8m0TMGvd8RQYsx2v1xvpKDYfn-0mG+gffHexnqCNxw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dorian Machado 2016-02-22 21:29:33 Re: [TIPS] Tuning PostgreSQL 9.2
Previous Message Ferrell, Denise SDC 2016-02-22 14:48:32 Extracting JSON data into columns