Rod Taylor <[EMAIL PROTECTED]> writes: > On Fri, 2006-05-05 at 14:31 -0400, Tom Lane wrote: >> Unless you had an actual backend crash, that's not an adequate >> explanation. Transaction abort does clean up created files.
> The only thing I can come up with is that perhaps someone forcefully > gave it a kick. SIGTERM is a necessary action once in a while to unwedge > a stuck db connection (killing the client script doesn't always get it > immediately). SIGTERM wouldn't cause that either. I hope your people are not in the habit of using "kill -9"? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend