Tom Lane wrote: > "Jouneau Luc" <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
