Re: [HACKERS] Solution for LIMIT cost estimation

Don Baccus <dhogaza@pacifier.com>

From: Don Baccus <dhogaza@pacifier.com>
To: Hannu Krosing <hannu@tm.ee>
Cc: chris@bitmead.com, pgsql-hackers@postgreSQL.org
Date: 2000-02-15T01:00:12Z
Lists: pgsql-hackers
At 02:43 AM 2/15/00 +0200, Hannu Krosing wrote:
>Don Baccus wrote:

>> Well...personally I don't see LIMIT as being particularly harmful,
>> and it is a convenience.  Remember, for the web space you're speaking
>> of keeping overhead low is a real concern, and requiring a series
>> of queries where currently only one needed will probably go over like
>> a lead ballon.
>
>I meant that the _backend_ could (in some distant future, when the 
>optimiser is perfect :) implement LIMIT as above sequence.

Oops!  Sorry...at the moment I'm near to loathing the very existence
of LIMIT so misunderstood :)



- Don Baccus, Portland OR <dhogaza@pacifier.com>
  Nature photos, on-line guides, Pacific Northwest
  Rare Bird Alert Service and other goodies at
  http://donb.photo.net.