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.