Your cursor pagination is probably losing rows (JS Dates vs Postgres microseconds)

Keyset (cursor) pagination is the standard fix for slow OFFSET queries. You sort by created_at plus id, encode the last row into a cursor, and ask for "rows older than this" on the next page. There's a bug in the most common way people build that cursor in Node, and it doesn't fail loudly. Rows just quietly go missing. In the worst case,... Weiterlesen: Your cursor pagination is probably losing rows (JS Dates vs Postgres …