DevHeads.net

Postings by Markus Angst

Out of memory while reading tuples

Hi,

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 <a href="https://odbc.postgresql.org/docs/config.html" title="https://odbc.postgresql.org/docs/config.html">https://odbc.postgresql.org/docs/config.html</a> 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.