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 312127efd9495dd4fb0725c1db06160e
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: Frank Dana
Date:
Subject: Re: [HACKERS] Problem with copying abstimes
Next
From: "Sergey V. Lunegov"
Date:
Subject: [HACKERS] subsribe