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

Re: Out of memory troubles with version

From: Ludek Finstrle <luf(at)pzkagis(dot)cz>
To: Filip Wuytack <filip(at)wuytack(dot)net>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Out of memory troubles with version
Date: 2005-12-13 14:18:08
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
> 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. 


  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
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.



In response to


pgsql-odbc by date

Next:From: =?iso-8859-1?q?Tomas_Sk=E4re?=Date: 2005-12-13 15:22:02
Subject: Re: Out of memory troubles with version
Previous:From: Filip WuytackDate: 2005-12-13 09:29:47
Subject: Out of memory troubles with version

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