Re: Rollback of Query Cancellation

Поиск
Список
Период
Сортировка
От Jasen Betts
Тема Re: Rollback of Query Cancellation
Дата
Msg-id gm31uq$vkk$2@reversiblemaps.ath.cx
обсуждение исходный текст
Ответ на Rollback of Query Cancellation  (Abdul Rahman <abr_ora@yahoo.com>)
Список pgsql-general
On 2009-01-28, Abdul Rahman <abr_ora@yahoo.com> wrote:
> --0-2110834523-1233119974=:72728
> Content-Type: text/plain; charset=us-ascii
>
> Dear All,
>
> Yesterday I canceled a running query because it was taking long time
> (more than 12 minutes) to delete lots of records. Today when I
> executed the same query it hardly took few seconds to finish. It
> clearly explores that PostgreSQL does not perform rollback action.
> Is it true?

it's true, but that's not proof. (the delete could have got held up by
a lock yesterday)


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

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: how to implement a foreign key type constraint against a not unique column
Следующее
От: Jasen Betts
Дата:
Сообщение: Re: ALTER TABLE with TYPE serial does not work