Shared Data Structure b/w clients

Started by Rohit Goyalover 11 years ago6 messages
#1Rohit Goyal
rhtgyl.87@gmail.com

Hi All,

I am working on postgresql code and having some problem. :)

I need to create shared data structure, so that different client and
connection can update and share the state of those data structures in
memory. I planned to use top memory context but it can give me shared
structure within one session/terminal.

Please tel me how postgresql do that and how i can do that?

Regards,
Rohit Goyal

#2Atri Sharma
atri.jiit@gmail.com
In reply to: Rohit Goyal (#1)
Re: Shared Data Structure b/w clients

On Tuesday, July 22, 2014, Rohit Goyal <rhtgyl.87@gmail.com> wrote:

Hi All,

I am working on postgresql code and having some problem. :)

I need to create shared data structure, so that different client and
connection can update and share the state of those data structures in
memory. I planned to use top memory context but it can give me shared
structure within one session/terminal.

Please tel me how postgresql do that and how i can do that?

Regards,
Rohit Goyal

How about making it a part of shared mem, like shared buffers?

Regards,

Atri

--
Regards,

Atri
*l'apprenant*

#3Rohit Goyal
rhtgyl.87@gmail.com
In reply to: Atri Sharma (#2)
Re: Shared Data Structure b/w clients

Hi Atri/All,

I am very new in postgresql code. Can you please help in a bit detail ortel
me how to create structure in shared memory(shared buffer).

It would be really easy for me if you can give me a code snippet or any
link to follow.

Regards,
Rohit Goyal

On Tue, Jul 22, 2014 at 8:30 PM, Atri Sharma <atri.jiit@gmail.com> wrote:

On Tuesday, July 22, 2014, Rohit Goyal <rhtgyl.87@gmail.com> wrote:

Hi All,

I am working on postgresql code and having some problem. :)

I need to create shared data structure, so that different client and
connection can update and share the state of those data structures in
memory. I planned to use top memory context but it can give me shared
structure within one session/terminal.

Please tel me how postgresql do that and how i can do that?

Regards,
Rohit Goyal

How about making it a part of shared mem, like shared buffers?

Regards,

Atri

--
Regards,

Atri
*l'apprenant*

--
Regards,
Rohit Goyal

#4Jaime Casanova
jaime@2ndquadrant.com
In reply to: Rohit Goyal (#3)
Re: Shared Data Structure b/w clients

On Tue, Jul 22, 2014 at 1:33 PM, Rohit Goyal <rhtgyl.87@gmail.com> wrote:

Hi Atri/All,

I am very new in postgresql code. Can you please help in a bit detail ortel
me how to create structure in shared memory(shared buffer).

It would be really easy for me if you can give me a code snippet or any link
to follow.

you can look at contrib/pg_stat_statements

--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566 Cell: +593 987171157

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

#5Craig Ringer
craig@2ndquadrant.com
In reply to: Rohit Goyal (#3)
Re: Shared Data Structure b/w clients

On 07/23/2014 02:33 AM, Rohit Goyal wrote:

I am very new in postgresql code. Can you please help in a bit detail
ortel me how to create structure in shared memory(shared buffer).

It would be really easy for me if you can give me a code snippet or any
link to follow.

There's a lot of detail on how to do this in the BDR codebase, see
contrib/bdr in
http://git.postgresql.org/gitweb/?p=2ndquadrant_bdr.git;a=summary

--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

#6Craig Ringer
craig@2ndquadrant.com
In reply to: Craig Ringer (#5)
Re: Shared Data Structure b/w clients

On 07/23/2014 09:46 AM, Craig Ringer wrote:

There's a lot of detail on how to do this in the BDR codebase, see
contrib/bdr in
http://git.postgresql.org/gitweb/?p=2ndquadrant_bdr.git;a=summary

Oh, sorry: in the bdr-next branch. Should've mentioned.

http://git.postgresql.org/gitweb/?p=2ndquadrant_bdr.git;a=tree;f=contrib/bdr;h=fad1aa59a15724deb98f9b923d84f0ce818afc1f;hb=refs/heads/bdr-next

--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers