Re: could you tell me this..?

Поиск
Список
Период
Сортировка
От Szymon Guz
Тема Re: could you tell me this..?
Дата
Msg-id AANLkTimk3aK3gauh6p96J-ZN7qn-Qo1B_W0HzOVOapc+@mail.gmail.com
обсуждение исходный текст
Ответ на could you tell me this..?  (백승엽 <sybaek@seriends.com>)
Ответы Re: could you tell me this..?  (Vick Khera <vivek@khera.org>)
Список pgsql-general


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 по дате отправления:

Предыдущее
От: 백승엽
Дата:
Сообщение: could you tell me this..?
Следующее
От: Ketema Harris
Дата:
Сообщение: Re: could you tell me this..?