> I'm trying to fetch a table (simple select * from table) which is 102
> columns and some 3.5 million rows. When running this I always end up
> having a "out of memory". (when I put a where statement or a limit in the
> SQL, it runs fine). I've tried tweaking the settings for the odbc setting
> in windows (is windows xp) and upgraded to version 8.01.01.02 (even tried
> to 103 snapshot), but the problem remains. I've attached both log files
> created by the odbc driver. I hope someone can give me some hints on way
> this is happening. I'm accessing the odbc dsn from within SAS 9.1.
Hello,
I know about this limitation. There is problem ODBC keep all rows
in memory (+ result from libpq = 2 x result). Please try check
Use Declare/Fetch option. There is no twice result in memory in psqlODBC.
If it doesn't help you can try older releases which mayde do not do this.
Please try 8.00.X or even 7.03.209 (if you find it somewhere).
I know we're suggesting 8.01.X but few people work with so big
datasets.
You can buy more memory too (only as quick hack if you need it fast).
We have a lot of bug reports (and so few developers) so I don't know
when we focus on this problem.
Regards,
Luf
