At a very high number of pages, LIMIT / OFFSET becomes extremely slow, even when using optimization techniques like this (although the times you're quoting are

At a very high number of pages, LIMIT / OFFSET becomes extremely slow, even when using optimization techniques like this (although the times you're quoting are for unoptimized queries). If you routinely need to go that deep through a paginated list, you probably want to look into other techniques.