Re: [HACKERS] Efficiency of LIMIT ?

From: Adam Haberlach <haberlaa(at)ricochet(dot)net>
To: Chris Bitmead <chris(dot)bitmead(at)bigfoot(dot)com>
Cc: pgsql-hackers(at)hub(dot)org
Subject: Re: [HACKERS] Efficiency of LIMIT ?
Date: 1999-04-25 18:49:46
Message-ID: 19990425114946.C1214@ricochet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ryan Bradetich 1999-04-25 19:32:02 Re: [HACKERS] create view as select distinct (fwd)
Previous Message Vadim Mikheev 1999-04-25 15:58:47 Re: [GENERAL] Vacuum Crash