Re: [HACKERS] stuck spin lock with many concurrent users

[Tom Lane]

Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> I have seen problems with extremely many concurrent users.
> I run pgbench:

> pgbench -c 1000 -t 1 test

> And I get stuck spin lock errors. This is 100% reproducable (i.e. I
> have nerver succeeded in pgbench -c 1000).

Is it actually stuck, or just timing out due to huge contention?
You could try increasing the timeout intervals in s_lock.c to
make sure.  If it is stuck, on which lock(s)?

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl