Re: JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Eileen <hey_here(at)yahoo(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem
Date: 2012-08-31 15:18:12
Message-ID: CAOR=d=2oew6u4ovuY2JMiFbfUtWkeJJX4tmKYGwcMfU76a_oMw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Aug 30, 2012 at 12:34 AM, Eileen <hey_here(at)yahoo(dot)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?

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2012-08-31 16:17:19 Re: exponential performance decrease in ISD transaction
Previous Message Albe Laurenz 2012-08-31 14:18:21 Re: JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem