Re: [HACKERS] libpq: why we need to fetch all rows? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] libpq: why we need to fetch all rows?
Date
Msg-id 2aed346e73827fe665458ec8f7da502b
Whole thread Raw
In response to [HACKERS] libpq: why we need to fetch all rows?  (Alexander Demenshin <aldem@techie.com>)
List pgsql-hackers
> Please give examples of true RDBMS SQL servers which return rows before
> completing the database scan.

My comments exactly.  I know of no such SQL engine.  Now, there are some
which will keep the RESULTS on the server, and only return them
one-by-one.  That may be a speed savings.  Also, if your query uses
ORDER BY, I am in the process of improving the performance of that code.

- --
Bruce Momjian
maillist@candle.pha.pa.us

------------------------------

pgsql-hackers by date:

Previous
From: Igor
Date:
Subject: [HACKERS] Case sensitivity in identifiers
Next
From: Igor
Date:
Subject: Re: [HACKERS] libpq: why we need to fetch all rows?