Certainly true, although that pain is something that can be at least partially mitigated in the backend. You can use approaches that are similar to exponential

Certainly true, although that pain is something that can be at least partially mitigated in the backend. You can use approaches that are similar to exponential backoff, just with LIMIT, so that you do end up filling up your page. While there's some annoying bookkeeping involved, it does work and it does scale.