Group Details Private
RE: Averaging the lag time (PostgreSQL)
@Onyx Given your actual results (assuming that
.is a decimal and not a thousands separator) it probably won't improve on that because the DB is already doing the optimizations. Which is the fun of optimizing SQL: you never know for sure what will happen until you try.
RE: To library or not to library, that is the question
@PleegWat I doubt there's a single metric that doesn't have counter examples. The best approach for a quick look is to have a diversity of metrics. But a quick look is only ever going to be that.