Re: What is postgresql doing for "statement: commit;begin;"

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: What is postgresql doing for "statement: commit;begin;"
Дата
Msg-id 1996.1105977188@sss.pgh.pa.us
обсуждение исходный текст
Ответ на What is postgresql doing for "statement: commit;begin;"  (Nick Burch <nick@torchbox.com>)
Ответы Re: What is postgresql doing for "statement: commit;begin;"  (Nick Burch <nick@torchbox.com>)
Список pgsql-general
Nick Burch <nick@torchbox.com> writes:
> Quite a lot, I'm seeing lines like:
> 2005-01-17 13:11:15 LOG:  duration: 4688.108 ms  statement: commit;begin;

> Is there any way to find out what exactly got executed here?

A whole lot of deferred-until-transaction-commit operations, evidently.
You got any deferred foreign keys in this database?

            regards, tom lane

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

Предыдущее
От: Bo Lorentsen
Дата:
Сообщение: Re: Index optimization ?
Следующее
От: "Frank D. Engel, Jr."
Дата:
Сообщение: Re: Index optimization ?