Re: [HACKERS] Thread-safe queueing?

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tim Holloway <mtsinc@southeast.net>
Cc: pgsql-hackers <pgsql-hackers@postgreSQL.org>
Date: 1999-11-13T15:14:21Z
Lists: pgsql-hackers
Tim Holloway <mtsinc@southeast.net> writes:
> I need to create a cross-process producer/consumer data queue
> (e.g. singly-linked list).  That is - Processes A, B, and C add nodes
> to a controlled list and process D removes them.  Not sure if the
> creation of the nodes would be best done by the producers or
> consumers, but destruction would have to be done by the consumer, as
> the producers don't wait for processing. For optimal results, the
> consumer process should sleep until item(s) are added to its queue.

> Query: within the existing backend framework, what's the best way to
> accomplish this?

More context, please.  What are you trying to accomplish?  Is this
really a communication path between backends (and if so, what backend
code needs it?), or are you trying to set up a queue between SQL
clients?  How much data might need to be in the queue at one time?

			regards, tom lane