Is PostgreSQL 9.3 using indexes for pipelined top-N window function queries?

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.