How do you write efficient pagination for millions of rows?

Efficient pagination is absolutely critical when dealing with millions of rows in PostgreSQL — especially if you care about performance, index usage, and UX for APIs or UI pages. 1. OFFSET/LIMIT Pagination (a.k.a. “Skip-Limit”) SELECT * FROM orders O...