2010/8/5 백승엽 <syb...@seriends.com> > Hi. > > > I am korean database engineer. > > my english skill is very poor. > > but i desire that you teach this situation. > > > um... > > I am testing postgresql performance in these days; > > today, I found this situation. > > > > Session 1. - > > begin; > delete from XXXX; > > > Session 2 - > > delete from XXXX; > > > thus, it occured row level locking. > > > > > so. i killed Session 1's PID with kill -9 commands > > >
killing it with -9 crashed the whole PostgreSQL server, don't do that. Instead just login to the database and run the function pg_cancel_backend() http://www.postgresql.org/docs/8.4/static/functions-admin.html, much more safe way. regards Szymon
