Re: [HACKERS] MVCC works in serialized mode!
Bruce Momjian <maillist@candle.pha.pa.us>
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: vadim@krs.ru (Vadim Mikheev)
Cc: hackers@postgreSQL.org
Date: 1998-12-16T18:00:34Z
Lists: pgsql-hackers
> 6. I'm not happy with current deadlock detection code! > It seems that backend does DeadLockCheck each time > when timer expired - shouldn't this be done _once_, > before backend is going to sleep ?! Not sure. Now that I think of it, it makes sense that if I go to sleep, a deadlock is not sudenly going to appear while I am asleep. If a new process causes a deadlock, the new process that causes it will see it. I did not check when I went to sleep because I thought it may be too cpu-intensive to do checking on every sleep, but now that I remember it, it may be very trivial in cpu time to do the check on every sleep. I recommend changing it to do it just before every sleep. Let me know if you want me to make the change. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026