Re: ule+smp: small optimization for turnstile priority lending

2012-11-06 Thread David Xu
On 2012/11/07 14:17, Jeff Roberson wrote: On Wed, 7 Nov 2012, David Xu wrote: On 2012/11/06 19:03, Attilio Rao wrote: On 9/20/12, David Xu wrote: On 2012/09/18 22:05, Andriy Gapon wrote: Here is a snippet that demonstrates the issue on a supposedly fully loaded 2-processor system: 136794

Re: pgbench performance is lagging compared to Linux and DragonflyBSD?

2012-11-06 Thread Lev Serebryakov
Hello, Wojciech. You wrote 6 ноября 2012 г., 13:25:05: WP> performance in normal unix style usage - multiple different programs doing WP> multiple different things for multiple different users - in the same time. WP> This is a case with at least 99% of users. The less than 1% that have so WP> hea

Re: pgbench performance is lagging compared to Linux and DragonflyBSD?

2012-11-06 Thread Samuel J. Greear
On Tue, Nov 6, 2012 at 2:01 PM, Yuri wrote: > On 11/06/2012 11:10, Samuel J. Greear wrote: >> >> Single and multi-socket hardware are not really directly comparable in >> PostgreSQL tests. > > > So if the CPUs are split between sockets, would such system generally > perform better or worse with Po

Re: ule+smp: small optimization for turnstile priority lending

2012-11-06 Thread David Xu
On 2012/11/06 19:03, Attilio Rao wrote: On 9/20/12, David Xu wrote: On 2012/09/18 22:05, Andriy Gapon wrote: Here is a snippet that demonstrates the issue on a supposedly fully loaded 2-processor system: 136794 0 3670427870244462 KTRGRAPH group:"thread", id:"Xorg tid 102818", state:"runnin

Re: pgbench performance is lagging compared to Linux and DragonflyBSD?

2012-11-06 Thread Yuri
On 11/06/2012 11:10, Samuel J. Greear wrote: Single and multi-socket hardware are not really directly comparable in PostgreSQL tests. So if the CPUs are split between sockets, would such system generally perform better or worse with PostgeSQL vs. non-split situation? Yuri ___

Re: [patch] md(4) and preloaded memory disks

2012-11-06 Thread Poul-Henning Kamp
In message <20121106182752.gb2...@a91-153-116-96.elisa-laajakaista.fi>, Jaakko Heinonen writes: >I plan to commit the patch below to disallow attaching preloaded memory >disks via ioctl. I didn't find anything that would really use this >undocumented feature. If I remember right, this w

Re: pgbench performance is lagging compared to Linux and DragonflyBSD?

2012-11-06 Thread Samuel J. Greear
On Tue, Nov 6, 2012 at 10:58 AM, Yuri wrote: > On 11/05/2012 12:52, Garrett Cooper wrote: >> >> FWIW, I think that the last time scheduler benchmarks from anyone at >> @FreeBSD.org (was kris@ the last one, or has flo@ run benchmarks since > > > I myself ran the similar test on i7 920 (4 cores 8 th

[patch] md(4) and preloaded memory disks

2012-11-06 Thread Jaakko Heinonen
Hi, I plan to commit the patch below to disallow attaching preloaded memory disks via ioctl. I didn't find anything that would really use this undocumented feature. --- Disallow attaching preloaded memory disks via ioctl. - The feature is dangerous because the kernel code doesn't check valid

Re: pgbench performance is lagging compared to Linux and DragonflyBSD?

2012-11-06 Thread Yuri
On 11/05/2012 12:52, Garrett Cooper wrote: FWIW, I think that the last time scheduler benchmarks from anyone at @FreeBSD.org (was kris@ the last one, or has flo@ run benchmarks since I myself ran the similar test on i7 920 (4 cores 8 threads) @ 2.67 24GB with 9.1-RC3 with all the same params

Re: pgbench performance is lagging compared to Linux and DragonflyBSD?

2012-11-06 Thread Garrett Cooper
On Nov 6, 2012, at 1:26 AM, Wojciech Puchar wrote: >> defaults) is sysctl/tunable variables set in the *BSD OSes (on DFly, >> FreeBSD, and NetBSD). Unfortunately (based on my experience) FreeBSD could >> be a lot better when it comes to defaults, and more tuning is required to > > actually Free

Re: pgbench performance is lagging compared to Linux and DragonflyBSD?

2012-11-06 Thread Garrett Cooper
On Nov 6, 2012, at 8:55 AM, Wojciech Puchar wrote: >>> Tuning operating system for single benchmark is an example of that childish >>> behaviour. >> >> LOL. That's what "we" did several years ago : >> http://people.freebsd.org/~kris/scaling/dfly.html > > i've seen that page some time ago but i

Re: pgbench performance is lagging compared to Linux and DragonflyBSD?

2012-11-06 Thread Samuel J. Greear
Your entire email is conjecture, the performance of DragonFly 3.2 is improved across the board vs 3.0. Not just batch performance, interactive performance (especially under X11) is also greatly improved. Sam On Tue, Nov 6, 2012 at 2:25 AM, Wojciech Puchar wrote: >> some serious system issue. >>

Re: pgbench performance is lagging compared to Linux and DragonflyBSD?

2012-11-06 Thread Wojciech Puchar
Tuning operating system for single benchmark is an example of that childish behaviour. LOL. That's what "we" did several years ago : http://people.freebsd.org/~kris/scaling/dfly.html i've seen that page some time ago but i don't really care of it. i just wasn't interested. Still - DOING such

Re: pgbench performance is lagging compared to Linux and DragonflyBSD?

2012-11-06 Thread Wojciech Puchar
Your entire email is conjecture, the performance of DragonFly 3.2 is improved across the board vs 3.0. Not just batch performance, interactive performance (especially under X11) is also greatly improved. i must try. i checked 3.0 and earlier versions and it was a disaster. Relative to FreeBSD o

Re: pgbench performance is lagging compared to Linux and DragonflyBSD?

2012-11-06 Thread Olivier Smedts
2012/11/6 Wojciech Puchar : > Tuning operating system for single benchmark is an example of that childish > behaviour. LOL. That's what "we" did several years ago : http://people.freebsd.org/~kris/scaling/dfly.html I won't blame dflybsd for benchmarking something specific. Maybe there is somethin

Re: ule+smp: small optimization for turnstile priority lending

2012-11-06 Thread Attilio Rao
On 9/20/12, David Xu wrote: > On 2012/09/18 22:05, Andriy Gapon wrote: >> >> Here is a snippet that demonstrates the issue on a supposedly fully >> loaded >> 2-processor system: >> >> 136794 0 3670427870244462 KTRGRAPH group:"thread", id:"Xorg tid >> 102818", >> state:"running", attributes: prio

Re: ule+smp: small optimization for turnstile priority lending

2012-11-06 Thread Attilio Rao
On 10/29/12, Attilio Rao wrote: > On Mon, Oct 29, 2012 at 4:56 PM, Attilio Rao wrote: >> On Wed, Oct 3, 2012 at 3:05 PM, Andriy Gapon wrote: >>> on 20/09/2012 16:14 Attilio Rao said the following: On 9/20/12, Andriy Gapon wrote: >>> [snip] > The patch works well as far as I can tell.

Re: pgbench performance is lagging compared to Linux and DragonflyBSD?

2012-11-06 Thread Wojciech Puchar
some serious system issue. It looks like the DragonflyBSD folks made a goal to do well on pgbench and got to the level of ~88% of linux with 80 clients. It's just bad that anyone judge and (even worse) modify/tune operating system to do well in SINGLE benchmark running basically single progra

Re: procstat -v question

2012-11-06 Thread Wojciech Puchar
Does that 182 resident pages mean that the process being displayed is referencing that many pages itself, or does that represent how many to THIS process. Long time ago when i asked about multiple programs mapping same large files - i learned that pagetables are always per process. When you

Re: pgbench performance is lagging compared to Linux and DragonflyBSD?

2012-11-06 Thread Wojciech Puchar
defaults) is sysctl/tunable variables set in the *BSD OSes (on DFly, FreeBSD, and NetBSD). Unfortunately (based on my experience) FreeBSD could be a lot better when it comes to defaults, and more tuning is required to actually FreeBSD defaults are actually good for COMMON usage. and can be tune