On 2009-01-28, Abdul Rahman <abr_ora@xxxxxxxxx> 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) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general