| From: | thomas at tada(dot)se (Thomas Hallgren) |
|---|---|
| To: | |
| Subject: | [Pljava-dev] Fw: out of memery |
| Date: | 2006-03-20 10:41:01 |
| Message-ID: | 441E86BD.60701@tada.se |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pljava-dev |
lifeng wrote:
> pljava-dev, hello?
>
> I set "log_min_messages = debug1" in "postgresql.conf" of pgsql. When the erro("out of memery") happened , i found the followed message in the configur file.
> ...
> SPI Proc: 273670144 total in 67 blocks; 3840 free (29 chunks); 273666304 used
> ...
> ExecutorState: 1141402016 total in 204 blocks; 7923848 free (3633 chunks); 1133478168 used
> ...
>
> It seems that the pl/java's class has enough memery and the error leads postgres process to terminate. How can i deal with the problem ?
>
>
This doesn't look good at all. It seems the ExecutorState MemoryContext
is collecting everything while your huge query is running. I'll have to
investigate this further and get back to you.
Regards,
Thomas Hallgren
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sriram Dandapani | 2006-03-21 06:56:27 | [Pljava-dev] pljava reninitializing jdbc connection pool for every invocation |
| Previous Message | lifeng | 2006-03-20 09:01:41 | [Pljava-dev] Fw: out of memery |