Re: Solaris - Mailing list pgsql-general

From Tom Lane
Subject Re: Solaris
Date
Msg-id 5082.1051240091@sss.pgh.pa.us
Whole thread Raw
In response to Re: Solaris  (Andrew Sullivan <andrew@libertyrms.info>)
Responses Re: Solaris  (Andrew Sullivan <andrew@libertyrms.info>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: Re: Question about performance
Next
From: Jonathan Bartlett
Date:
Subject: Re: Factoring where clauses through UNIONS take 2