[01:10] <wgrant> Hmm.
[01:10] <wgrant> Only 583 timeouts.
[01:10] <wgrant> Perhaps the lack of index bloat is useful.
[09:31] <LPCIBot> Yippie, build fixed!
[09:31] <LPCIBot> Project devel build #894: FIXED in 5 hr 41 min: https://lpci.wedontsleep.org/job/devel/894/
[21:43] <lifeless> mtaylor: so
[21:43] <lifeless> mtaylor: when are we getting those blueprints patches ? :)
[21:44] <mtaylor> heh. hehehehe
[21:44] <mtaylor> lifeless: which ones was I going to do again?
[21:44] <lifeless> I dunno
[21:44] <mtaylor> and wait - aren't you meging them with bugs?
[21:44] <lifeless> you had some openstack wishlist thingies
[21:44] <lifeless> yeah, and ?
[21:45] <mtaylor> well, I finally have another guy working with me
[21:45] <lifeless> oh oh oh
[21:45] <mtaylor> who is doing some hacking - although he's heads down in jenkins and gerrit right now
[21:45] <lifeless> did you see we got the bugsummary fact/dimension setup going ?
[21:45] <mtaylor> BUT - we should be able to get to some of these sorts of things eventually now (bandwidth is good)
[21:45] <mtaylor> I didn't - what do those words mean?
[21:45] <lifeless> data warehousing approach
[21:46] <lifeless> a fact table - a table with (0,1) rows per unique combination of dimensions (in this case bugtasktarget, status, importance, has-patch, fixed-upstream, viewable-by)
[21:46] <mtaylor> lovely!
[21:47] <lifeless> and then you slice n dice the table to pull out stats
[21:47] <lifeless> it has a column containing the counter for how many tasks matched that point in the table space
[21:48] <lifeless> e.g. on https://bugs.launchpad.net/ubuntu/
[21:48] <lifeless> the two portlets - tags and the counts
[21:48] <lifeless> used to take 10+ seconds each to render
[21:48] <lifeless> now the tags one is subsecond and the count one is 1.3 seconds 99% of the time, and not over 2s ever in the stats I've looked at
[21:49] <lifeless> oh, tag is another dimension
[21:50] <mtaylor> excellent!
[21:50] <mtaylor> nicely done
[21:50] <lifeless> in the last 6 months we've dropped out 99% render time site wide
[21:50] <lifeless> ... by 50%
[22:20] <mtaylor> lifeless: you know what - puppet is great except when it's not
[22:26] <lifeless> orly? software not being great?
[22:31] <lifeless> I'm shocked