From: | "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp> |
---|---|
To: | Markus Angst <mangst(at)inventec(dot)ch> |
Cc: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Out of memory while reading tuples |
Date: | 2018-11-07 02:17:59 |
Message-ID: | 0935d1c8-e51b-08de-5bfc-ca8c7546ee45@dream.email.ne.jp |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Juan Tiritas | 2018-11-07 06:55:35 | Re: Does the psqlodbc driver support asynchronous queries? |
Previous Message | Leonardo De La Cerda | 2018-11-07 00:03:30 | Re: Problem compiling in mac os with unix odbc |