4 ms·
You should really read this: https://www.slideshare.net/MarkusWinand/p2d2-pagination-done-the-postgresql-way https://www.slideshare.net/MarkusWinand/p2d2-pagina
by ahachete 9y ago
You should really read this: https://www.slideshare.net/MarkusWinand/p2d2-pagination-done-the-postgresql-way https://www.slideshare.net/MarkusWinand/p2d2-pagination-done...
- whateveracct 9y agoYep the Seek Method for pagination as suggested there would cause you to be sorting by UUID. SELECT uuid FROM t where filterable_field > $whatever and uuid > $lastSeen limit $pageSize with a covering index on (filterable_field, uuid)