Andrew Sullivan <andrew@libertyrms.info> writes:
> There's something fishy with the SYSV shared memory management, but
> I'm darned if I can figure out what it is.
Hmm, you're still running 7.2.*, right? There's some code added in 7.3
to enable "intimate shared memory" on Solaris:
#if defined(solaris) && defined(__sparc__)
/* use intimate shared memory on SPARC Solaris */
memAddress = shmat(shmid, 0, SHM_SHARE_MMU);
#else
memAddress = shmat(shmid, 0, 0);
#endif
I disremember the details but we were told this would improve
performance. It'd be an easy enough patch in 7.2
(src/backend/storage/ipc/ipc.c about line 638) if you care to try it.
regards, tom lane