Re: [HACKERS] Update on my 6.4.2 progress

> 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026