From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Alex Vinogradovs <AVinogradovs(at)Clearpathnet(dot)com> |
Cc: | Jeff Davis <pgsql(at)j-davis(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: SPI shared memory ? |
Date: | 2007-09-22 03:50:44 |
Message-ID: | 1469.1190433044@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Alex Vinogradovs <AVinogradovs(at)Clearpathnet(dot)com> writes:
> Yes, I'd like to get some memory of my own, so that it can
> be shared between functions executing in different connections.
> Is there an existent API, or should I just straight use Unix IPC ?
As of (I think) 8.2, there's RequestAddinShmemSpace and RequestAddinLWLocks.
However, the fly in the ointment is that you can only usefully call
these from a loadable module that is preloaded at postmaster start;
otherwise it is too late to affect the sizing of shared memory.
There's enough slop in the shared memory allocation that you can
probably grab a few dozen or hundred bytes without a pre-allocation.
One possibility is to do that and use it to store a reference to a
separate shared memory segment.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Christian Schröder | 2007-09-22 05:08:10 | Re: Performance Issues |
Previous Message | Merlin Moncure | 2007-09-22 02:43:45 | Re: Migration from PervasiveSQL |