Scott Marlowe <scott.marlowe@xxxxxxxxx> writes: > On Wed, Sep 20, 2017 at 12:14 PM, Jerry Sievers <gsievers19@xxxxxxxxxxx> 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.consulting@xxxxxxxxxxx >> p: 312.241.7800 >> >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) >> 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.consulting@xxxxxxxxxxx p: 312.241.7800 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
