16 Actions

How to avoid the SORT operation in SQL query that contains ORDER_BY condition?Side-node: It's not a PostgreSQL limitation. OFFSET is bad in any database. Also: the solution shown in the slides is generally applicable to all databases (that's why I renamed the slides "Pagination done the right way"). Nevertheless, PostgreSQL is the only DB with proper row-values support which makes the "seek method" easy to implement. And thanks for linking my slides :)