Setting up a database for 10000 concurrent users
От | Poul Møller Hansen |
---|---|
Тема | Setting up a database for 10000 concurrent users |
Дата | |
Msg-id | 431CA928.9000605@pbnet.dk обсуждение исходный текст |
Ответы |
Re: Setting up a database for 10000 concurrent users
Re: Setting up a database for 10000 concurrent users Re: Setting up a database for 10000 concurrent users |
Список | pgsql-general |
I'm trying to setup a database for 10000 concurrent users for a test. I have a system with 1GB of RAM where I will use 512MB for PostgreSQL. It is running SuSE 9.3 I have changed SHMMAX & SHMALL echo "536870912" >/proc/sys/kernel/shmmax echo "536870912" >/proc/sys/kernel/shmall and max_connections = 10000 in postgresql.conf When trying to start the database server it leaves this in the log. FATAL: could not create semaphores: No space left on device DETAIL: Failed system call was semget(5432129, 17, 03600). HINT: This error does *not* mean that you have run out of disk space. It occurs when either the system limit for the maximum number of semaphore sets (SEMMNI), or the system wide maximum number of semaphores (SEMMNS), would be exceeded. You need to raise the respective kernel parameter. Alternatively, reduce PostgreSQL's consumption of semaphores by reducing its max_connections parameter (currently 5000). Calculated the values should be SEMMNI = 10000 / 16 SEMMNS = (10000 / 16) * 17 "plus room for other applications" How much should that be ? And where can I change those values on a 2.6 kernel ? Poul
В списке pgsql-general по дате отправления: