From: thomas at tada.se (Thomas Hallgren)
Date: Wed, 22 Mar 2006 07:26:13 +0100
Subject: [Pljava-dev] pljava causes postgres to consume excessive memory
In-Reply-To: <6992E470F12A444BB787B5C937B9D4DF03C48C2A@ca-mail1.cis.local>
References: <6992E470F12A444BB787B5C937B9D4DF03C48C2A@ca-mail1.cis.local>
Message-ID: <4420EE05.5010906@tada.se>

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
>
>