QlikView desktop unresponsive while fetching even 1 row
I am connecting Postgres 9.1.22 using 64 bit ODBC driver. In PostgresSQL we have huge table which has 80 GB size and 100 million rows. If I tried to fetch even 1 rows using QlikView my desktop application hangs forever. We tried it for 2 hours then killed task.
Any idea if there are issues with QlikView ODBC driver? Please suggest if any better driver can help in resolving this issue. OLEDB / JDBC preferred opensource driver.