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

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem
Дата
Msg-id CAOR=d=2oew6u4ovuY2JMiFbfUtWkeJJX4tmKYGwcMfU76a_oMw@mail.gmail.com
обсуждение исходный текст
Ответ на JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem  (Eileen <hey_here@yahoo.com>)
Список pgsql-performance
On Thu, Aug 30, 2012 at 12:34 AM, Eileen <hey_here@yahoo.com> 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?


В списке pgsql-performance по дате отправления:

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: Re: JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: exponential performance decrease in ISD transaction