[GENERAL] Upgrade to 9.3 - performance issue ?
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Upgrade to 9.3
unsubscribe On Mon, Jul 21, 2014 at 1:22 PM, Alan Hodgson wrote: > On Monday, July 21, 2014 09:05:18 PM Karthik Iyer wrote: > > Hello, > > > > We are planning to upgrade Postgres from 9.0 to 9.3. Was wondering > > if there are any serious changes that I have to look out for > > (syntax/datatypes changes) so that my code does not break. > > > > http://www.postgresql.org/docs/9.1/static/release-9-1.html > http://www.postgresql.org/docs/9.3/static/release-9-2.html > http://www.postgresql.org/docs/9.3/static/release-9-3.html > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- *Christian Jensen* 2151 Burnside Road West Unit #5 Victoria, BC V9B 0P5 +1 (778) 996-4283 christ...@jensenbox.com
Re: [GENERAL] Upgrade to 9.3
On Monday, July 21, 2014 09:05:18 PM Karthik Iyer wrote: > Hello, > > We are planning to upgrade Postgres from 9.0 to 9.3. Was wondering > if there are any serious changes that I have to look out for > (syntax/datatypes changes) so that my code does not break. > http://www.postgresql.org/docs/9.1/static/release-9-1.html http://www.postgresql.org/docs/9.3/static/release-9-2.html http://www.postgresql.org/docs/9.3/static/release-9-3.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Upgrade to 9.3
Hello, We are planning to upgrade Postgres from 9.0 to 9.3. Was wondering if there are any serious changes that I have to look out for (syntax/datatypes changes) so that my code does not break. Thanks in advance. - Karthik -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general