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 change for high
number of users.
Thanks.
Regards,
Jignesh
Simon Riggs wrote:
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
the I/O-induced contention reduction.
Is there a way we can integrate this in 8.3?
I just replied to Josh's thread on -hackers about this.
This will improve out of box performance quite a bit for high number of
users (atleat 30% in my OLTP test)
Yes, thats good. Will this have a dramatic effect on a particular
benchmark, or for what reason might we need this? Tom has questioned the
use case here, so I think it would be good to explain a little more for
everyone. Thanks.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
