Current status: deduplicating 12.6 million database rows
@joepie91 having a normal one
@tobi This is like, at worst, only the fifth most cursed thing I have been doing to my database today
@tobi Heh :p CTEs are like sub-expressions, so now my query looks something like this: https://gist.github.com/joepie91/6a2e2c585c3864f2bf660840cd6f9356
@joepie91 oof, jesus!
@tobi The old version of this query is actually worse (and, apparently, broken): https://git.cryto.net/joepie91/srap/src/branch/master/src/database-backends/postgresql/queries/get-task-stream.js#L22
@tobi Old one is also easily 5x as slow
@joepie91 I'm not sure what that could mean apart from cwick-time event, I wish you the best of luck in pressing the buttons at the right time!