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

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
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-09-01 00:43:49
Message-ID: 50415A45.4060506@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 08/30/2012 02:34 PM, Eileen wrote:

> In my case, a few problems occurred. Number 1, the process ran at least
> 8 hours and never finished.

You're on a very old version of Pg, so you're missing out on a lot of
improvements made since then.

One of them is, if I recall correctly, an improvement to exception
handling efficiency. Does your function use BEGIN ... EXCEPTION to (say)
handle data validation errors?

--
Craig Ringer

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2012-09-01 02:12:28 Re: NOTIFY performance
Previous Message Tom Lane 2012-08-31 20:22:59 Re: NOTIFY performance