PostgreSQL OFFSET/LIMIT pagination gets slower as pages get deeper. Here’s how to use keyset (seek/cursor) pagination with the right index for consistent performance.