stuck spin lock with many concurrent users

Поиск
Список
Период
Сортировка
От Tatsuo Ishii
Тема stuck spin lock with many concurrent users
Дата
Msg-id 20010620182800A.t-ishii@sra.co.jp
обсуждение исходный текст
Ответы Re: stuck spin lock with many concurrent users  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
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).

This is Linux kernel 2.2.18. Followings are some resource settings
that seem crytical to me.

kernel.shmall = 134217728
kernel.shmmax = 134217728
fs.file-max = 65536

There are 1GB physical memory and 2GB swap space. Note that same
things happen in Sparc/Solaris with much less users (500 concurrent
users).
--
Tatsuo Ishii


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Meskes
Дата:
Сообщение: Re: RE: Universal admin frontend
Следующее
От: Pedro Abelleira Seco
Дата:
Сообщение: RE: RE: Universal admin frontend