Postgres Pro
Downloads
Home   >   mailing lists

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

From Simon Riggs
Subject Re: LIMIT/SORT optimization
Date
Msg-id 1176020653.3623.611.camel@silverbirch.site
Whole thread Raw
In response to Re: LIMIT/SORT optimization  (Bruce Momjian <bruce@momjian.us>)
List pgsql-patches
Tree view 
On Sat, 2007-04-07 at 22:16 -0400, Bruce Momjian wrote:

> > The patch is faster until we hit 100k or 10% of the table, at which
> > point it is the same speed.  What is interesting is 1M is also the same
> > speed:

All tests good, AFAICS. Thanks Bruce.

Patch is operating as expected: the common case is considerably faster
and the uncommon case isn't any slower.

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com

pgsql-patches by date:

Previous
From: "Marko Kreen"
Date:
Subject: RESET SESSION v3
Next
From: "Simon Riggs"
Date:
Subject: Re: Heap page diagnostic/test functions (v2)