Re: Upgrade Ubuntu - PostgresSQL is ok?

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: James David Smith <james(dot)david(dot)smith(at)gmail(dot)com>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Upgrade Ubuntu - PostgresSQL is ok?
Date: 2015-01-09 17:15:37
Message-ID: 54B00CB9.8000300@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 01/09/2015 03:05 AM, James David Smith wrote:
> Hi there,
>
> I have a server running Ubuntu 12.04 LTS. On this machine, I have the
> following PostgreSQL version installed:
>
> PostgreSQL 9.3.5 on X86 64-unkown-linux-gnu, compiled by gcc
> (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit
>
> Ubuntu has been prompting me to upgrade my distribution to '14.04.1
> LTS' for a few months now. But I've resisted as I'm nervous about it
> causing problems with my PostgreSQL database. It's essential to the
> work that I am doing at the moment.
>
> So my question is, am I worrying over nothing? Should I just go ahead
> and upgrade Ubuntu distribution?
>
>
Do make sure you have a good PostgreSQL dump prior to any upgrades, of
course, but to upgrade or not depends on how much time you have to test,
do the upgrade, and fix any resulting issues compared to any benefits
you feel you will get.

BUT! Do be aware that the default kernel in 12.04 has some "lethally
bad" performance problems
(http://www.databasesoup.com/2014/11/good-kernel-bad-kernel.html)

I recently upgraded some systems from 12.04 to 14.04 with no changes to
PostgreSQL and am now happily free of the query timeout errors that had
started to plague me.

Whether or not that is important to you depends on how you are using
PostgreSQL.

Cheers,
Steve

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message David G Johnston 2015-01-09 17:18:03 Re: Convert boolean field to a 0 or a 1 in a select statement
Previous Message Steve Crawford 2015-01-09 16:54:27 Re: Convert boolean field to a 0 or a 1 in a select statement