Re: LIMIT/SORT optimization

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Gregory Stark <gsstark(at)mit(dot)edu>, Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: LIMIT/SORT optimization
Date: 2007-03-14 14:20:14
Message-ID: 87odmvnbz5.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches


Bruce Momjian <bruce(at)momjian(dot)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

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Hannu Krosing 2007-03-14 14:59:39 Re: [PATCHES] Bitmapscan changes
Previous Message Heikki Linnakangas 2007-03-14 10:22:00 Re: [PATCHES] Bitmapscan changes