[Pljava-dev] out of memery

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
>

In response to

Browse pljava-dev by date

  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