Upgrade to 9.3 - performance issue ?

From: Karthik Iyer <karthik(dot)i(at)directi(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Upgrade to 9.3 - performance issue ?
Date: 2014-08-08 09:58:53
Message-ID: 53E49F5D.10303@directi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

We were planing to upgrade from 9.0 to to 9.3. While
investigating on the performance side, we stumbled upon a link which
says there may be performance degradation on 9.3:

http://postgresql.1045698.n5.nabble.com/upgrade-from-9-2-x-to-9-3-causes-significant-performance-degradation-td5771288.html

So we are planning to do this post the upgrade:

echo never > /sys/kernel/mm/transparent_hugepage/enabled
echo never > /sys/kernel/mm/transparent_hugepage/defrag

Wanted to understand, If there are any other such tweaks that we need to
take care of, before we go 9.3

Some details:

OS: CentOS 6.2
Kernel: 2.6.32-431.20.3.el6.x86_64

Help here is appreciated.

Thanks in advance,

- Karthik

Browse pgsql-general by date

  From Date Subject
Next Message Andreas 2014-08-08 10:43:56 Re: How to get PG 9.3 for a RaspberryPI (Debian Wheezy)?
Previous Message vpmm2007 2014-08-08 05:23:00 Re: postgresql referencing and creating types as record