The error you are encountering in Qlik Sense, “Out of memory while reading tuples,” typically occurs when the PostgreSQL ODBC driver attempts to fetch an entire large result set into memory at once. This can be mitigated by enabling the Use Declare/Fetch option in the ODBC settings, which allows the driver to use server-side cursors and fetch rows in smaller chunks instead of loading all rows at once. Alongside this, setting the Cache Size to a high value, such as 100,000, determines how many rows are fetched per round trip from the server, balancing memory usage and performance. Both settings are supported by Qlik Sense and can help prevent memory allocation errors while working with large datasets. E-ZPass New Hampshire
