Postgres Pro
Downloads
Home   >   mailing lists

will 8.4 be able to optmize rank() windows ? - Mailing list pgsql-performance

From Grzegorz Jaśkiewicz
Subject will 8.4 be able to optmize rank() windows ?
Date
Msg-id 2f4958ff0902240707u75904ad3qc4bb013b5b398801@mail.gmail.com
Whole thread Raw
List pgsql-performance
Tree view 
Question to core developers
if I rank() a table, grouping by foo - but only will want to get first
X result for every rank.
Will postgresql be able to optimize that, or is it something left over
for 8.5 in general?


--
GJ

pgsql-performance by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: planner's midjudge number of rows resulting, despite pretty obvious join
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: TCP network cost