reosarevok: well, I did find a way to avoid a seq scan, but I overestimated how much it helps. for this artist, my "improved" query finishes in 37 seconds (rather than timing out after 60s :P)
reosarevok
bitmap: well, that's an improvement :p
But yeah, not great
So feel free to revert, and if you'd rather not revert between now and the schema change maybe apply the changes for now?
I guess we'll want to still make use of that *and* a materialized table eventually anyway
bitmap
we can deploy the new tables before the schema change, though the triggers aren't quite ready yet so it'll have to wait for those
jesus crist is tht what he web looks liek witouth adblockers
ah youtube viewo, cheers Lotheric
sumedh joined the channel
yubhav has quit
_lucifer
alastairp, ruaok: do we have somewhere to document things which might be useful while writing/reviewing code? for example, flask's treatment of `/` at the end of a route so on.
ruaok
not yet. maybe a page on the wiki?
_lucifer
i was thinking we should probably have a document in the repo and add a note in the default issue template linking to that
ruaok
which repo?
I like the link.
_lucifer
that's a good question. some things might apply to multiple repos other might be specific
ruaok
which is why the wiki page might be good.
we can make sub-pages for python, perl, flask, etc.
_lucifer
yeah, that sounds good. let's do it with the wiki
alastairp
wait, I think we have one of them already!
chaban
!m reosarevok for improving search help box
BrainzBot
You're doing good work, reosarevok for improving search help box!
chaban
What do you think of MBS-11374? Forgot to mention that one when I updated the description yesterday
chaban: I saw that, I thought I'd take a look at some point later. Not quite sure how that query would work, it should be doable I guess but it might be quite slow? bitmap might be better for it
bitmap
can we just construct an edit search to link to?
reosarevok
No, because release linked edits include all those "non-release-level" ones
So I don't think there's a way to filter those. At least now
bitmap
you can filter which edit types to include, doesn't that help?