Rollback of Query Cancellation

From: Abdul Rahman <abr_ora(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Rollback of Query Cancellation
Date: 2009-01-28 05:19:34
Message-ID: 931477.72728.qm@web65713.mail.ac4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Regards,
Abdul Rehman.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message justin 2009-01-28 05:32:06 Re: Rollback of Query Cancellation
Previous Message Fujii Masao 2009-01-28 02:47:36 Re: New 8.4 hot standby feature