Untitled attachment

Notices where this attachment appears

1. Embed this notice
   Stefan Marr (smarr@mastodon.acm.org)'s status on Monday, 11-Mar-2024 23:48:45 JST Stefan Marr

   in reply to

   @freemo @freemo@qoto.org

   The concrete query is in the Gist here: https://gist.github.com/smarr/5a30c34cc38e274f634b151d9763f93c

   On the partial table, an index on (runId, trialId, criterion, invocation) helps. Though, since this converts the full table, adding that index doesn't make any performance difference for the full conversion.

   I added a comment on the Gist with the `EXPLAIN ANALYZE` output. It's the first time doing performance work on this type of stuff, so, many unknowns on my end....