Tom Lane wrote:
> "Jouneau Luc" <Luc.Jouneau@jouy.inra.fr> writes:
> > We plan to install on a same Solaris server an Oracle8i and a PostgreSQL
> > 7.3.4 database.
> > During our impact tests, we encountered a situation where no more semaphore
> > was available for Oracle server (while we where bulk loading on postgreSQL
> > using copy statement. There was only one PG connection while there were many
> > on Oracle server).
> > I quote that our kernel configuration (semaphore and shared memory
> > parameters) had been previously correctly positionned as required in Oracle
> > and postgreSQL documentation.
>
> Obviously not. I suspect you forgot to add up the semaphore
> requirements of each package ...
Also, we grab all semaphores we will need for max connections at startup
so we don't fail under load so that might have surprised you.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073