> The interesting thing is, we went and put in another 128 mb of ram (from
> 256 to 384 now) and recompiled the kernel with more semaphores and shared
> memory, and the improvement was incredible! Before, we would get semget
> failures every so often when we had about 50 backends going, causing the
> whole thing to fall over, but now we get
> "fmgr_info: function 111257088: cache lookup failed"
> after 64 backends (which is what we compiled postgres for) which I
> assume isn't so fatal and the whole system keeps running.
The 6.4.2 code would not allocate all shared memory/semaphores at
startup, and only fail when you go to a large number of backends. 6.5
fixes this by allocating it all on startup.
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026