Re: Setting up a database for 10000 concurrent users - Mailing list pgsql-general

From Poul Møller Hansen
Subject Re: Setting up a database for 10000 concurrent users
Date
Msg-id 431CAC9F.9010706@pbnet.dk
Whole thread Raw
In response to Setting up a database for 10000 concurrent users  (Poul Møller Hansen <freebsd@pbnet.dk>)
List pgsql-general
> 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 ?
>

I will try to answer myself with another question.
Can it be that it should be changed in
/usr/src/linux/include/linux/sem.h

#define SEMMNI  128 /* <= IPCMNI  max # of semaphore identifiers */
#define SEMMSL  250 /* <= 8 000 max num of semaphores per id */
#define SEMMNS  (SEMMNI*SEMMSL) /* <= INT_MAX max # of semaphores in
system */


Poul

pgsql-general by date:

Previous
From: Poul Møller Hansen
Date:
Subject: Setting up a database for 10000 concurrent users
Next
From: Daniel Morgan
Date:
Subject: Debug plpgSQL stored procedures