From: | SHOBHA HALDONKAR <shobha(at)phildigital(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | deadlock detection |
Date: | 2003-04-08 06:03:58 |
Message-ID: | 3E92664D.313C3DFE@phil.com.sg |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
HI ,
We are currenlty using postgresql 7.2.1 database. But it does not
seem to detect deadlocks .
Suppose if a record is locked with update command and another
concurrent user tries to lock the same record and the first transaction
for some reason , eg. m/c hangings is not committed both the
transactions remains locked for indefinite period . I have checked the
setting in postgresql.config for deadlock_timeout which is set to 1000
. Than why doesn't the transaction deatect deadlock after 1000
millisecond .
Secondly if the frontend process is killed but due to some reason the
backend postgres process remains , than how can it be terminated .For
if i try to use kill command all the postgres processes gets
terminated .
Please help
--
Regards,
Shobha
From | Date | Subject | |
---|---|---|---|
Next Message | mlaks | 2003-04-08 07:11:18 | trouble connecting to Postgresql Database via apache-perl script on localhost ? pg_hba.conf issue |
Previous Message | Nikolaus Dilger | 2003-04-08 03:50:42 | Re: Trying to Tunning DB |