ndex for all my
Foreign Key fields.
Tina
From: Dave Cramer
To: Eileen
Cc: "pgsql-performance@postgresql.org"
Sent: Friday, August 31, 2012 6:50 AM
Subject: Re: [PERFORM] JDBC 5 million function insert returning Single
Transaction Lock Access Exclusive Problem
Dave Cramer
dave.crame
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 improvemen
On Thu, Aug 30, 2012 at 12:34 AM, Eileen 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 ge
Eileen wrote:
> 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 these functions on postgresql 8.3 on Windows.
When I t
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
these functions on postgresql 8.3 on Windows. When I tried runni
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Thu, Aug 30, 2012 at 2:34 AM, Eileen 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