Re: Kill a session

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Kill a session
Дата
Msg-id 22033.1152894313@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Kill a session  ("Craig A. James" <cjames@modgraph-usa.com>)
Список pgsql-performance
"Craig A. James" <cjames@modgraph-usa.com> writes:
> It's also possible that the INSERT itself is the problem, or adds to the problem.  The SIGINT may come after a few
millionrows have been inserted, so it would have to clean that up, right? 

No, because we don't use UNDO.  The next VACUUM would have a bit of a
mess to clean up, but you wouldn't pay for it at the time of the abort.

            regards, tom lane

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

Предыдущее
От: "Craig A. James"
Дата:
Сообщение: Re: Kill a session
Следующее
От: worky.workerson@gmail.com
Дата:
Сообщение: Self-join query and index usage