News for hackers. Stuff that matters.
Re:Making a Postgres query 1k times faster by astralagent on Friday May 24, 2024 @01:22AM (#40463052)
Given Post.ID is monotonically increasing and this is a cursor-based pagination query, can this WHERE clause be effectively rewritten as:

WHERE Posts.CreateAt >= ?1 AND Posts.Id > ?2 (where ?1 and ?2 are the current cursor values)

There are no comments on this comment yet.