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?
Best regards,
Behrang Saeedzadeh
Behrang Saeedzadeh