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