Re: Rollback of Query Cancellation

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Rollback of Query Cancellation
Date: 2009-02-01 02:38:18
Message-ID: gm31uq$vkk$2@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2009-01-28, Abdul Rahman <abr_ora(at)yahoo(dot)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)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jasen Betts 2009-02-01 02:45:31 Re: ALTER TABLE with TYPE serial does not work
Previous Message Jasen Betts 2009-02-01 02:35:39 Re: how to implement a foreign key type constraint against a not unique column