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