View Single Post

   
  #2 (permalink)  
Old 04-16-2008, 02:39 AM
=?iso-8859-1?q?Tomas_Sk=E4re?=
 
Posts: n/a
Default Re: Out of memory troubles with version 8.01.01.02

Ludek Finstrle <luf@pzkagis.cz> writes:

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


Does it keep everything in memory when using cursors too?


Tomas

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Reply With Quote