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

Out of memory troubles with version

From: Filip Wuytack <filip(at)wuytack(dot)net>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Out of memory troubles with version
Date: 2005-12-13 09:29:47
Message-ID: (view raw, whole thread or download thread mbox)
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 (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,


Description: application/x-zip-compressed (7.6 KB)


pgsql-odbc by date

Next:From: Ludek FinstrleDate: 2005-12-13 14:18:08
Subject: Re: Out of memory troubles with version
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-2017 The PostgreSQL Global Development Group