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

Re: Out of memory troubles with version 8.01.01.02

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 8.01.01.02
Date: 2005-12-13 14:18:08
Message-ID: 20051213141808.GA5689@soptik.pzkagis.cz (view raw or flat)
Thread:
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  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

In response to

Responses

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 8.01.01.02
Previous:From: Filip WuytackDate: 2005-12-13 09:29:47
Subject: Out of memory troubles with version 8.01.01.02

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