Re: [PERFORM] 60 core performance with 9.3

2014-07-11 Thread Kevin Grittner
Mark Kirkwood wrote: > On 11/07/14 20:22, Andres Freund wrote: >> So, the majority of the time is spent in numa page migration. >> Can you disable numa_balancing? I'm not sure if your kernel >> version does that at runtime or whether you need to reboot. >> The kernel.numa_balancing sysctl might w

Re: [PERFORM] 60 core performance with 9.3

2014-07-11 Thread Mark Kirkwood
On 11/07/14 20:22, Andres Freund wrote: On 2014-07-11 12:40:15 +1200, Mark Kirkwood wrote: Postgres 9.4 beta rwlock patch pgbench scale = 2000 On that scale - that's bigger than shared_buffers IIRC - I'd not expect the patch to make much of a difference. Right - we did test with it bigger

Re: [PERFORM] 60 core performance with 9.3

2014-07-11 Thread Andres Freund
On 2014-07-11 12:40:15 +1200, Mark Kirkwood wrote: > On 01/07/14 22:13, Andres Freund wrote: > >On 2014-07-01 21:48:35 +1200, Mark Kirkwood wrote: > >>- cherry picking the last 5 commits into 9.4 branch and building a package > >>from that and retesting: > >> > >>Clients | 9.4 tps 60 cores (rwlock)