By the way, we finally understood that our main problem,
the one that was making our Pg hang forever, comes from
a deadlock problem. Same as Hannu's one.
There are no deadlock detection, indeed. Good DBAs, or
DBAs working with good coders, will never come across
the problem :) but we did :(
I th
Fabrice Scemama <[EMAIL PROTECTED]> writes:
> By the way, we finally understood that our main problem,
> the one that was making our Pg hang forever, comes from
> a deadlock problem. Same as Hannu's one.
> There are no deadlock detection, indeed. Good DBAs, or
> DBAs working with good coders, wil
Hannu Krosing <[EMAIL PROTECTED]> writes:
> I'm in a situation where I urgently need to debug PostgreSQL 7.0.2
> for deadlocks that it does not notice/timeout
The most likely bet is that you are seeing deadlocks that involve a
buffer spinlock (LockBuffer() in bufmgr.c) --- there's no timeout or
Hi,
I'm in a situation where I urgently need to debug PostgreSQL 7.0.2
for deadlocks that it does not notice/timeout
Where can I find info about running several concurrent backends
under a debugger ?
---
Hannu
