Re: Kill a session - Mailing list pgsql-performance

From Tom Lane
Subject Re: Kill a session
Date
Msg-id 22033.1152894313@sss.pgh.pa.us
Whole thread Raw
In response to Re: Kill a session  ("Craig A. James" <cjames@modgraph-usa.com>)
List 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 by date:

Previous
From: "Craig A. James"
Date:
Subject: Re: Kill a session
Next
From: worky.workerson@gmail.com
Date:
Subject: Self-join query and index usage