On Monday February 17 2003 4:31, Mona Gamboa wrote: > ok...here's the output.[kinda nasty to read]
Nothing obvious to me. If it is reproduceable, you might try turning on some of the lock tracing directives in postgresql.conf and/or increasing the logging level. You might also try attaching to the hung process in gdb to see where it is hanging, and post the backtrace and see if anyone recognizes anything, e.g. gdb <PATH-TO-PSQL> <PID> gdb> bt Ed ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org