On: Postgres 9.5 feature highlight: row-level security...

[cvburgess]

I would really like to see an implementation of MySQL's SQL_CALC_FOUND_ROWS. It's super handy for pagination.

[masklinn → cvburgess]

According to http://www.percona.com/blog/2007/08/28/to-sql_calc_found_row... (which is a very old thread and may be completely outdated), it's also often much slower than just doing two queries.

[cvburgess → masklinn]

Good to know!

Although, like you said, that thread dates back to MySQL 5.0 - I wouldn't hedge my bets on it today...

Is there a "best practices" way to handle pagination of complex queries without running the query twice?