Don't use LIMIT OFFSET for pagination in PostgreSQL

  • What would be the downsides of using cursor based pagination? There has to be something, otherwise it be used solely.