Re: setFetchSize - Mailing list pgsql-jdbc

From Fernando Nasser
Subject Re: setFetchSize
Date
Msg-id 3F16A541.6010703@redhat.com
Whole thread Raw
In response to setFetchSize  (Felipe Schnack <felipes@ritterdosreis.br>)
Responses Re: setFetchSize [Viruschecked]  ("Patric Bechtel" <bechtel@ipcon.de>)
List pgsql-jdbc
Felipe Schnack wrote:
>   There is a way that I can set setFetchSize() that will prevent pgsql from caching all the results of a query to
server'smemory? 
>   I'm trying to search in the archives but any search I try returns 0 results...
>

Have you tried setting it to a positive value and turning off autocommit
(you must be inside a transaction to do this)?

--
Fernando Nasser
Red Hat Canada Ltd.                     E-Mail:  fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario   M4P 2C9


pgsql-jdbc by date:

Previous
From: Felipe Schnack
Date:
Subject: setFetchSize
Next
From: "Patric Bechtel"
Date:
Subject: Re: setFetchSize [Viruschecked]