Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 24 Feb 2009 15:07:18 +0000
- Message-id: <2f4958ff0902240707u75904ad3qc4bb013b5b398801@mail.gmail.com> <text/plain>
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
- Prev by Date: Re: planner's midjudge number of rows resulting, despite pretty obvious join
- Next by Date: Re: TCP network cost
- Previous by thread: planner's midjudge number of rows resulting, despite pretty obvious join
- Next by thread: full text search - dictionary caching
- Indexes: