Re: Out of memory while reading tuples

Hi Hiroshi,

>>> Postgres 10.4 64bit on Windows
>>> psqlODBC 10.03.0000
>>> - Use Declare/Fetch is off
>>> - Cache size is 10'000'000
>>>
>>> Issuing a simple select statement with Microsoft Access gives me the
>>> following ODBC error:
>>>
>>> "Out of memory while reading tuples.; memory allocation error??? (#4)"
>>>
>>> The statement returns 822701 rows (via JDBC), average row size is 100
>>> bytes.
>>>
>>> On https://odbc.postgresql.org/docs/config.html it says:
>>> "Cache Size: When using cursors, this is the row size of the tuple
>>> cache. If not using cursors, this is how many tuples to allocate
>>> memory for at any given time. The default is 100 rows for either case."
>>
>> Hmm, it seems a documentation bug to me.
>>
>>   "If not using cursors, this is how many tuples to allocate memory at
>> first."
>>
>> seems correct.
>
> Oops, I was wrong.
>
>   "If not using cursors, this has no meaning."
>
> seems right.

Thanks for your reply. What is the exact memory limit (and, out of curiosity:
why does it exist)?

Regards
Markus Angst