I am running into the same problem - has there been a fix for this? It seems, the logflare subscription does not properly process the data and makes postgres lock WAL files basically indefinitely. As soon as I restart analytics, postgres disk usage drops because the WAL files get released.
> It’ll suck. I have to iterate all matches and calculate match statistics, placement and advancement points, shortest pin and tech fall times…. That’ll be horrific in sql. Really? I mean, SQL is particularly for correlating and processing a lot of data in a performant and structured way. I don't know your level of SQL wizardry but would look at common table expressions (CTEs). I love them and it's just the right thing to do to represent your business logic in SQL if you can.