Re: SELECT's take a long time compared to other DBMS - Mailing list pgsql-performance

On Thu, 2003-09-04 at 22:13, Relaxin wrote:
> Finally, someone who will actually assume/admit that it is returning the
> entire result set to the client.
> Where as other DBMS manage the records at the server.

Is there a reason you can't use cursors (explicitely, or via ODBC if it
provides some glue on top of them) to keep the result set on the server?

http://candle.pha.pa.us/main/writings/pgsql/sgml/sql-declare.html
http://candle.pha.pa.us/main/writings/pgsql/sgml/sql-fetch.html

> The next one is the handling of BLOBS.  PG handles them like no other system
> I have ever come across.

Just FYI, you can use both the lo_*() functions, as well as simple
bytea/text columns (which can be very large in PostgreSQL).

-Neil