Skip site navigation (1) Skip section navigation (2)

Re: Getting number of matched records from query

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Michael Owens <mike(at)mikesclutter(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Getting number of matched records from query
Date: 2003-11-02 05:58:00
Message-ID: 20031101214918.D58021@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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-LynneDate: 2003-11-02 10:10:15
Subject: SQL supported features list
Previous:From: StephenDate: 2003-11-02 05:45:08
Subject: Re: Experimental patch for inter-page delay in VACUUM

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group