Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: mylog_4756.zip
Description: application/x-zip-compressed (7.6 KB)

Responses

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group