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

From: Behrang Saeedzadeh <behrangsa(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Is PostgreSQL 9.3 using indexes for pipelined top-N window function queries?
Date: 2014-02-15 01:35:51
Message-ID: CAERAJ+8qzwQad4S2d4fuqE7U=6TkkdKBEWR1gFRpWyNxDUGR=w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2014-02-15 05:02:06 Re: Is it reasonable to store double[] arrays of 30K elements
Previous Message bhargavi 2014-02-14 23:04:02 Re: Postgres 9.3 Installation Problems Windows 7 64 Bit Pro