agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

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

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

view thread (2+ messages)

Message-ID: <4420EE05.5010906@tada.se>
Permalink:  ../4420EE05.5010906@tada.se/
Also on:    postgresql.org/message-id/4420EE05.5010906@tada.se

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] pljava causes postgres to consume excessive memory
  In-Reply-To: <4420EE05.5010906@tada.se>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox