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