From: | thomas at tada(dot)se (Thomas Hallgren) |
---|---|
To: | |
Subject: | [Pljava-dev] out of memery |
Date: | 2006-03-15 11:06:37 |
Message-ID: | 4417F53D.2080904@tada.se |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Olarte | 2006-03-15 16:12:29 | [Pljava-dev] out of memery |
Previous Message | lifeng | 2006-03-15 10:22:54 | [Pljava-dev] out of memery |