Re: Kill a session

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Craig A(dot) James" <cjames(at)modgraph-usa(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org, sgunderson(at)bigfoot(dot)com
Subject: Re: Kill a session
Date: 2006-07-14 16:25:13
Message-ID: 22033.1152894313@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Craig A. James" <cjames(at)modgraph-usa(dot)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 million rows 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message worky.workerson 2006-07-14 18:56:53 Self-join query and index usage
Previous Message Craig A. James 2006-07-14 15:17:38 Re: Kill a session