Postgres Pro
Downloads
Home   >   mailing lists

Re: JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem
Date
Msg-id CAOR=d=2oew6u4ovuY2JMiFbfUtWkeJJX4tmKYGwcMfU76a_oMw@mail.gmail.com
Whole thread Raw
In response to JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem  (Eileen <hey_here@yahoo.com>)
List pgsql-performance
Tree view 
On Thu, Aug 30, 2012 at 12:34 AM, Eileen <hey_here@yahoo.com> wrote:
> Hi,
>
> I have written some Java code which builds a postgresql function.  That
> function calls approximately 6 INSERT statements with a RETURNING clause.  I
> recreate and re-run the function about 900,000 times.  I use JDBC to execute

That's generally a pretty inefficient way of doing things.  Can you
create a function that does what you want and not drop / recreate it
over and over?

pgsql-performance by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem
Next
From: Jeff Janes
Date:
Subject: Re: exponential performance decrease in ISD transaction