Re: [HACKERS] Efficiency of LIMIT ? - Mailing list pgsql-hackers

From Adam Haberlach
Subject Re: [HACKERS] Efficiency of LIMIT ?
Date
Msg-id 19990425114946.C1214@ricochet.net
Whole thread Raw
In response to Efficiency of LIMIT ?  (Chris Bitmead <chris.bitmead@bigfoot.com>)
Responses Re: [HACKERS] Efficiency of LIMIT ?  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
On Sun, Apr 25, 1999 at 08:16:58AM +0000, Chris Bitmead wrote:
> 
> Is the LIMIT feature very efficient? I want to start using it for quite
> a few things, but I'm wondering, what happens when I have a zillion
> records and I want the first 10, is that going to be an efficient thing
> to do?
I am curious about this myself.  As far as I can tell, it doesn't
give anything that cursors don't provide, but introduces more "features"
into the parser.  Do we need this?



pgsql-hackers by date:

Previous
From: Chris Bitmead
Date:
Subject: Efficiency of LIMIT ?
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Efficiency of LIMIT ?