| From: | Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> |
|---|---|
| To: | Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Suggestions on message transfer among backends |
| Date: | 2019-03-12 05:59:41 |
| Message-ID: | 6dec8f7a-f019-67ca-9eca-ef10f53e74ff@postgrespro.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 11/03/2019 18:36, Andy Fan wrote:
> Hi:
> I need some function which requires some message exchange among
> different back-ends （connections).
> specially I need a shared hash map and a message queue.
>
> Message queue: it should be many writers, 1 reader. Looks POSIX
> message queue should be OK, but postgre doesn't use it. is there any
> equivalent in PG?
>
> shared hash map: the number of items can be fixed and the value can be
> fixed as well.
>
> any keywords or explanation will be extremely helpful.
You may use shm_mq (shared memory queue) and hash tables (dynahash.c) in
shared memory (see ShmemInitHash() + shmem_startup_hook)
>
> Thanks
--
Andrey Lepikhov
Postgres Professional
https://postgrespro.com
The Russian Postgres Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2019-03-12 06:03:16 | Re: current_logfiles not following group access and instead follows log_file_mode permissions |
| Previous Message | Michael Paquier | 2019-03-12 05:42:14 | Re: Compressed TOAST Slicing |