Re: Setting up a database for 10000 concurrent users

From: Poul Møller Hansen <freebsd(at)pbnet(dot)dk>
To: Poul Møller Hansen <freebsd(at)pbnet(dot)dk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Setting up a database for 10000 concurrent users
Date: 2005-09-05 20:37:51
Message-ID: 431CAC9F.9010706@pbnet.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Morgan 2005-09-05 20:40:43 Debug plpgSQL stored procedures
Previous Message Poul Møller Hansen 2005-09-05 20:23:04 Setting up a database for 10000 concurrent users