Postgres Pro
Downloads
Home   >   mailing lists

Thread: will 8.4 be able to optmize rank() windows ?

will 8.4 be able to optmize rank() windows ?

From
Grzegorz Jaśkiewicz
Date:
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