Re: [PERFORM] CLOG Patch

2007-08-10 Thread Simon Riggs
On Fri, 2007-08-10 at 13:54 -0400, Jignesh K. Shah wrote: > I tried with CLOG 24 also and I got linear performance upto 1250 users > after which it started to tank. 32 got us to 1350 users before some > other bottleneck overtook it. Jignesh, Thanks for testing that. It's not very clear to eve

Re: [PERFORM] CLOG Patch

2007-08-10 Thread Jignesh K. Shah
I tried with CLOG 24 also and I got linear performance upto 1250 users after which it started to tank. 32 got us to 1350 users before some other bottleneck overtook it. Based on what Tom said earlier, it might then make sense to make it a tunable with the default of 8 but something one can c

Re: [PERFORM] CLOG Patch

2007-08-03 Thread Simon Riggs
On Fri, 2007-08-03 at 16:09 -0400, Jignesh K. Shah wrote: > This patch seems to work well (both with 32 and 64 value but not with 16 > and the default 8). Could you test at 24 please also? Tom has pointed out the additional cost of setting this higher, even in workloads that don't benefit from

[PERFORM] CLOG Patch

2007-08-03 Thread Jignesh K. Shah
Hi Simon, This patch seems to work well (both with 32 and 64 value but not with 16 and the default 8). Is there a way we can integrate this in 8.3? This will improve out of box performance quite a bit for high number of users (atleat 30% in my OLTP test) Regards, Jignesh Simon Riggs wrote