Re: Out of memory while reading tuples

On 2018/11/07 1:10, Markus Angst wrote:
> 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)?

Psqlodbc itself doesn't have such a limitation. *Out of memory* means 
that psqlodbc requested
a memory area using m(re)alloc function but the system replied that it's 
a tall order.

BTW simple queries rather consume large amount of memory.
Could you narrow down the conditions of your queries?

regards,
Hiroshi Inoue


>
> Regards
> Markus Angst


---
このメールは、AVG によってウイルス チェックされています。
http://www.avg.com