Postgres Pro
Downloads
Home   >   mailing lists

Re: could you tell me this..? - Mailing list pgsql-general

From Szymon Guz
Subject Re: could you tell me this..?
Date
Msg-id AANLkTimk3aK3gauh6p96J-ZN7qn-Qo1B_W0HzOVOapc+@mail.gmail.com
Whole thread Raw
In response to could you tell me this..?  (백승엽 <sybaek@seriends.com>)
Responses Re: could you tell me this..?
List pgsql-general
Tree view


2010/8/5 백승엽 <sybaek@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

pgsql-general by date:

Previous
From: 백승엽
Date:
Subject: could you tell me this..?
Next
From: Ketema Harris
Date:
Subject: Re: could you tell me this..?