On Thu, Aug 30, 2012 at 12:34 AM, Eileen <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
