Postgres Pro
Downloads
Home   >   mailing lists

Re: LIMIT/SORT optimization - Mailing list pgsql-patches

From Gregory Stark
Subject Re: LIMIT/SORT optimization
Date
Msg-id 87odmvnbz5.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: LIMIT/SORT optimization  (Bruce Momjian <bruce@momjian.us>)
Responses Re: LIMIT/SORT optimization  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-patches
Tree view 
Bruce Momjian <bruce@momjian.us> writes:

> Is there a newer version of this patch?

As requested, I've cut an updated version of this patch against CVS HEAD:

 http://community.enterprisedb.com/sort-limit-v5.patch.gz

The open issues I see are:

 Adjusting the costing of the sort to take into account the optimization

 Whether the communication between the Limit node and the Sort node is kosher
 or whether something more abstract is needed.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com

pgsql-patches by date:

Previous
From: Jeff Davis
Date:
Subject: Synchronized Scan WIP patch
Next
From: Gregory Stark
Date:
Subject: Re: LIMIT/SORT optimization