Postings by Markus Angst

Out of memory while reading tuples


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="" title=""></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.