Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group