will 8.4 be able to optmize rank() windows ?

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: will 8.4 be able to optmize rank() windows ?
Date: 2009-02-24 15:07:18
Message-ID: 2f4958ff0902240707u75904ad3qc4bb013b5b398801@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Browse pgsql-performance by date

  From Date Subject
Next Message Ross J. Reedstrom 2009-02-24 17:02:01 Re: TCP network cost
Previous Message Pavel Stehule 2009-02-24 14:43:01 Re: planner's midjudge number of rows resulting, despite pretty obvious join