Re: setFetchSize

From: Fernando Nasser <fnasser(at)redhat(dot)com>
To: Felipe Schnack <felipes(at)ritterdosreis(dot)br>
Cc: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: setFetchSize
Date: 2003-07-17 13:31:45
Message-ID: 3F16A541.6010703@redhat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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's memory?
> 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(at)redhat(dot)com
2323 Yonge Street, Suite #300
Toronto, Ontario M4P 2C9

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Patric Bechtel 2003-07-17 14:12:32 Re: setFetchSize [Viruschecked]
Previous Message Felipe Schnack 2003-07-17 13:24:16 setFetchSize