> There are 1532240 tuples in pg_largeobject, and their size is about
> 3GB. But where I run this code, the client's main memory is exhausted.
> It seems that the client try to get all the tuples before it fetches
> the first 100.
>
> What's wrong? How can I fixed it?
What connection string? What's the settings in odbc.ini?
The first question is if you are using declare/fetch.
Could you send us the mylog output?
Regards,
Luf