Why offset pagination breaks at scale, and what to use instead

If your feed uses LIMIT and OFFSET, it feels fine in development and falls apart in production. The reason is simple: the database still has to walk every row it skips. The problem with OFFSET Say you