Re: Any known issues Pg 9.3 on Ubuntu Xenial kernel 4.4.0?

Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> writes:

> On Wed, Sep 20, 2017 at 12:14 PM, Jerry Sievers <gsievers19(at)comcast(dot)net> wrote:
>
>> Basically as per $subject.
>>
>> We took a perf hit moving up to newer hardware and OS version which
>> might in some cases be OK but admittedly there is some risk running a
>> much older app (Pg 9.3) on a kernel/OS version that nowhere near existed
>> when 9.3 was current.
>
> Are you sure you're using the same locale etc as you were on the old
> db? The most common cause of performance loss when migrating is that
> the new db uses a locale like en_US while the old one might have been
> in locale=C

No change there. enUS-utf8 in both cases.

Thanks

>
>>
>> Be curious to hear of issues encountered and particular to eager to know
>> if disabling any kernel 4.x features helped.
>>
>> Thanks
>>
>> PostgreSQL 9.3.19 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.4) 5.4.0 20160609, 64-bit
>>
>>
>> $ uname -a
>> Linux foo.somehost.com 4.4.0-92-generic #115-Ubuntu SMP Thu Aug 10 09:04:33 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux
>>
>> --
>> Jerry Sievers
>> Postgres DBA/Development Consulting
>> e: postgres(dot)consulting(at)comcast(dot)net
>> p: 312.241.7800
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>
>
>
> --
> To understand recursion, one must first understand recursion.

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres(dot)consulting(at)comcast(dot)net
p: 312.241.7800