Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux