Driver memory usage on select and autocommit

From: Silvio Bierman <sbierman(at)jambo-software(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Driver memory usage on select and autocommit
Date: 2008-10-29 09:16:49
Message-ID: 49082A01.9090405@jambo-software.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Can anyone explain why the PostgreSQL JDBC driver caches the result of a
select statement in memory even though I have set a fetch size. Only
setting autocommit to off will prevent this but that seems very
counterintuitive.

Any explanations?

Best regards,

Silvio Bierman

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2008-10-29 11:33:05 Re: Driver memory usage on select and autocommit
Previous Message Oliver Jowett 2008-10-27 23:50:55 Re: Unexpected value in Time object