On Sat, 1 Nov 2003, Michael Owens wrote:
> Isn't this information (the number of matched records) available to the
> backend --- even in the case of LIMIT? All matched records still have to be
> materialized right? Therefore the record count should be available and could
> therefore be available to the client. Is this correct?
No. For many plans, the entire record set does not have to be fully
materialized in the presence of LIMIT. In general, the limit node should
have the effect of making such plans more likely to be chosen.
In response to
pgsql-hackers by date
|Next:||From: Christopher Kings-Lynne||Date: 2003-11-02 10:10:15|
|Subject: SQL supported features list|
|Previous:||From: Stephen||Date: 2003-11-02 05:45:08|
|Subject: Re: Experimental patch for inter-page delay in VACUUM|