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

Foreign Key fields. Tina From: Dave Cramer p...@fastcrypt.com To: Eileen hey_h...@yahoo.com Cc: pgsql-performance@postgresql.org 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

[PERFORM] JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem

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