pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
9.0 performance degradation with kernel 3.11 2+ messages / 2 participants [nested] [flat]
* 9.0 performance degradation with kernel 3.11 @ 2014-11-13 08:10 Filip Rembiałkowski <filip.rembialkowski@gmail.com> 2014-11-14 16:08 ` Re: 9.0 performance degradation with kernel 3.11 Glyn Astill <glynastill@yahoo.co.uk> 0 siblings, 1 reply; 2+ messages in thread From: Filip Rembiałkowski @ 2014-11-13 08:10 UTC (permalink / raw) To: pgsql-performance Hi After upgrading our 9.0 database server from: openSUSE 11.4, kernel 2.6.37.6-24-default, Pg 9.0.13 to: openSUSE 13.1, kernel v 3.11.10-21-default, Pg 9.0.15 ... and overall server load is +1 after that. We did not add any new services/daemons. It's hard to track down to individual queries - when I tested most individual query times are same as before the migration. Any - ANY - hints will be much appreciated. Thanks Filip -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: 9.0 performance degradation with kernel 3.11 2014-11-13 08:10 9.0 performance degradation with kernel 3.11 Filip Rembiałkowski <filip.rembialkowski@gmail.com> @ 2014-11-14 16:08 ` Glyn Astill <glynastill@yahoo.co.uk> 0 siblings, 0 replies; 2+ messages in thread From: Glyn Astill @ 2014-11-14 16:08 UTC (permalink / raw) To: Filip Rembiałkowski <filip.rembialkowski@gmail.com>; pgsql-performance > From: Filip Rembiałkowski <filip.rembialkowski@gmail.com> >To: pgsql-performance@postgresql.org >Sent: Thursday, 13 November 2014, 8:10 >Subject: [PERFORM] 9.0 performance degradation with kernel 3.11 > > >Hi > >After upgrading our 9.0 database server > >from: >openSUSE 11.4, kernel 2.6.37.6-24-default, Pg 9.0.13 > >to: >openSUSE 13.1, kernel v 3.11.10-21-default, Pg 9.0.15 > >... and overall server load is +1 after that. > >We did not add any new services/daemons. > >It's hard to track down to individual queries - when I tested most >individual query times are same as before the migration. > > >Any - ANY - hints will be much appreciated. > >Thanks >Filip > It's hard to say much going on the little information, but assuming everything was rosy for you with your 2.6 version, and you've kept the basics like hardware, filesystem, io scheduler etc the same, there are a few kernel tunables to tweak on later kernels. Usually defragmentation of transparent huge pages causes an issue and it's best to turn off the defrag option: echo always > /sys/kernel/mm/transparent_hugepage/enabled echo madvise > /sys/kernel/mm/transparent_hugepage/defrag It's also recommended to increase the value of sched_migration_cost (I think now called sched_migration_cost_ns in 3.11+) and disable sched_autogroup_enabled. kernel.sched_migration_cost=5000000 kernel.sched_autogroup_enabled=0 Also disable vm.zone_reclaim_mode vm.zone_reclaim_mode=0 On some of our systems I also saw marked improvements increasing the values of kernel.sched_min_granularity_ns and kernel.sched_wakeup_granularity_ns too, on some other systems this had no effect. So you may want to try to see if some larger values there help. A lot of the earlier 3.x kernels aren't great with PostgreSQL, one of the noted issues being a "stable pages" feature that blocks processes modifying pages that are currently being written back until the write completes. I think people have noted this gets better in 3.9 onwards, but I personally didn't see much of a marked improvement until 3.16. >Thanks >Filip > -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2014-11-14 16:08 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2014-11-13 08:10 9.0 performance degradation with kernel 3.11 Filip Rembiałkowski <filip.rembialkowski@gmail.com> 2014-11-14 16:08 ` Glyn Astill <glynastill@yahoo.co.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox