Out of memory troubles with version 8.01.01.02

From: Filip Wuytack <filip(at)wuytack(dot)net>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Out of memory troubles with version 8.01.01.02
Date: 2005-12-13 09:29:47
Message-ID: 439E948B.1080703@wuytack.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi All,

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.

Many thanks,

Filip

Attachment Content-Type Size
mylog_4756.zip application/x-zip-compressed 7.6 KB

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Ludek Finstrle 2005-12-13 14:18:08 Re: Out of memory troubles with version 8.01.01.02
Previous Message Ludek Finstrle 2005-12-12 19:35:46 Re: Access violation C5 error on Visual FoxPro SQLEXEC() call after error