On Thu, Aug 30, 2012 at 12:34 AM, Eileen <hey_here@xxxxxxxxx> 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? -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
