On Fri, 10 Jun 2005 19:17:58 +0900 Junji TERAMOTO <[EMAIL PROTECTED]> wrote:
> Hello Mark, > > Mark Wong wrote: > > http://developer.osdl.org/markw/postgrescvs/ > > This site includes "Profile Report". It's very interesting and useful! > > Then, I compared result of 5/29 with the result of 5/30. > > new-order transactions per minute > 20050529 1779.41 > 20050530 2320.41 > > And I looked Profile Report, Top 20 by Tick. > > http://khack.osdl.org/stp/302458/profile/Framework_Close-tick.top20 > http://khack.osdl.org/stp/302468/profile/Framework_Close-tick.top20 It looks like the 20050530 run might be bogus. If we look at the top of the page here: http://khack.osdl.org/stp/302468/results/0/ The number of rollbacks are way too high. There should only be 1% for New Order only. I should to refer to the specification to see if I should be counting those rolled back transaction. My intuition tells me I've made a mistake in doing so. ;) What you were seeing in the profiles are mostly a side effect of that. The database had crashed so all the transactions were failing right away. We can see that here: http://khack.osdl.org/stp/302468/results/0/db/log Mark ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])