agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] out of memery
Date: Wed, 15 Mar 2006 12:06:37 +0100
Message-ID: <4417F53D.2080904@tada.se> (raw)
In-Reply-To: <20060315102305.5E39C187DCD@smtp.263.net>
References: <20060315102305.5E39C187DCD@smtp.263.net>
Hi Lifeng,
PL/Java does not impose limitations on the size of a result set. The set
is always perused one row at a time and PL/Java will not make attempts
to bring everything into memory.
What JDBC driver are you using? Are you setting the 'setFetchSize' on
the result set? Perhaps the default is to fetch everything in one go?
Regards,
Thomas Hallgren
lifeng wrote:
> pljava-dev-request,???
>
> HI. I used pl/java's function to get resultset from the remote database . When the result was 1GB, i got 'out of memery' error .
> SERVER : p42.8G , 768MB RAM
> JVM MEMERY : 384MB
>
> I don't know where the problem happened . Can pl/java deal with these datas? I hope to get a correct answer.
> Thank you very much.
>
>
>
> ????????lifeng
> ????????lifenggod at 263.net
> ??????????2006-03-15
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>
view thread (7+ messages) latest in thread
Message-ID: <4417F53D.2080904@tada.se>
Permalink: ../4417F53D.2080904@tada.se/
Also on: postgresql.org/message-id/4417F53D.2080904@tada.se
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] out of memery
In-Reply-To: <4417F53D.2080904@tada.se>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox