OutOfMemory - Mailing list pgsql-jdbc

From postgres@nitwit.de
Subject OutOfMemory
Date
Msg-id 200403291742.36480.postgres@nitwit.de
Whole thread Raw
Responses Re: OutOfMemory  (Alexander Staubo <alex@byzantine.no>)
List pgsql-jdbc
Hi!

I'm not sure whether this is a Java or an DB issue. I select a lot of data
from database, more than would fit into memory - and get an
OutOfMemoryException.

Well, why is this? This is actually what the idea of an Iterator is about,
that the data is progressively fetch and not all at once put into memory,
isn't it?

Now I do have to manually run the query multiple times using LIMIT/OFFSET
(manually adapted to the amount of RAM of the host machine...).

Timo

pgsql-jdbc by date:

Previous
From: "Freddy Villalba Arias"
Date:
Subject: Support for 2-Phase Commit protocol
Next
From: "Wagner,Harry"
Date:
Subject: Re: OutOfMemory