Hi, I just stumbled upon this article from 2012 [1], according to which (emphasis mine):
Window functions offer yet another way to implement pagination in SQL. This is a flexible, and above all, standards-compliant method. However, only SQL Server and the Oracle database can use them for a pipelined top-N query. *PostgreSQL does not use indexes for those queries and therefore executes them very inefficiently.* MySQL does not support window functions at all. Is this still the case? Or is PostgreSQL 9.3 capable to execute suchlike queries efficiently? [1] http://use-the-index-luke.com/sql/partial-results/window-functions Best regards, Behrang Saeedzadeh
