From: | thomas at tada(dot)se (Thomas Hallgren) |
---|---|
To: | |
Subject: | [Pljava-dev] pljava causes postgres to consume excessive memory |
Date: | 2006-03-22 06:26:13 |
Message-ID: | 4420EE05.5010906@tada.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
Hi Sriram,
I'm just fixed bug
http://gborg.postgresql.org/project/pljava/bugs/bugupdate.php?1542. From the sound of it, you are affected by it. What platform are you on? Are you able to compile from source?
Kind Regards,
Thomas Hallgren
Sriram Dandapani wrote:
> Hi Thomas
>
> When using pljava to issue jdbc commands, the memory consumed by
> postgres is a lot more than when not using jdbc.
>
> We use pljava with a jdbc connection to simulate autonomous transactions
> of the kind that Oracle provides.
>
> One of our application requirements is the insert of a large chunk of
> data (this scenario happens occasionally but it is something we need to
> take into account). When say inserting 4 million rows in a table with a
> jdbc command that does a "insert into select * from"
> The top command shows the insert command as a separate process that
> consumes most of the memory and also a postmaster writer process that
> also consumes a lot of memory
>
> Whe I run the same insert from pgadmin, the memory usage seems to be
> managed well by just the postmaster process and there is no separate
> writer process that consumes memory.
>
> Why does postgres/pljava behave this way.
>
> Regards
>
> Sriram
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Shulman, Michael | 2006-03-22 15:27:14 | [Pljava-dev] PostgreSQL 8.1 Pljava install problem |
Previous Message | Sriram Dandapani | 2006-03-22 01:28:12 | [Pljava-dev] pljava causes postgres to consume excessive memory |