Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> 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