Re: [PERFORM] 9.2.3 upgrade reduced pgbench performance by 60%

2013-03-26 Thread Nicholson, Brad (Toronto, ON, CA)
> -Original Message- > From: pgsql-performance-ow...@postgresql.org [mailto:pgsql- > performance-ow...@postgresql.org] On Behalf Of Josh Berkus > Sent: Monday, March 25, 2013 4:34 PM > To: pgsql-performance@postgresql.org > Subject: Re: [PERFORM] 9.2.3 upgrade reduced pgbench performance by

Re: [PERFORM] [OT] linux 3.10 kernel will improve ipc,sysv semaphore scalability

2013-03-26 Thread Shaun Thomas
On 03/26/2013 08:04 AM, Andrea Suisani wrote: TPS: 100 users: 1257.21 (vanilla)2805.06 (v3 patchset) 400 users: 1437.57 (vanilla)2664.67 (v3 patchset) 800 users: 1236.89 (vanilla)2750.73 (v3 patchset) Wow, I like the look of that. I wonder how this reacts with disabled autogroupin

[PERFORM] [OT] linux 3.10 kernel will improve ipc,sysv semaphore scalability

2013-03-26 Thread Andrea Suisani
Hi all, Just to let the community know that probably Linux kernel 3.10 will include some work to make sysv semaphore code more scalable. Since Postgres use this kernel features I've thought to post it here just for the sake of sharing a good news: The thread where Rik van Riel posts the v3 patch